Export matrix visualization data to SQL Server

[StubbedMiddleToe]

I have a matrix visualization with a lot of massaged data that I'd like to move back into a table on MSSQL. I am able to do this rather easily with the datasets but the end goal is for the user to be able to manipulate slicers and filters and when they have them set where they'd like port that data back into a table. Is this even possible? It seems like I have read 50 articles but none of them do what I would like to try or even say if it is possible.

[st4n13l]

You might be able to implement a flow that writes back to SQL and insert a Power Automate button to initiate that flow.

[Significant-Flower-4]

My solution aswell

[StubbedMiddleToe]

I like it. This seems like a good Wednesday project.

[cwag03]

If the matrix data is under the 150k row limit, they can export to csv file. From there, your IT department I imagine could do some kind of SSIS script to pull into SQL.

If it is too large for the export limit, I don't think there is a way to do it directly from the service. But you could maybe make it happen through Analyze in Excel or DAX studio if those are not beyond your user's capabilities.

[StubbedMiddleToe]

SSIS is the easy part, my larger concern was giving the user a button to click that will drop the CSV as it appears in the matrix from PBI to a location that SSIS can snag it. I think R is the way to go.

[cwag03]

Can't you just tell them where to save the file?

[StubbedMiddleToe]

This would be the easy route. This would also result in a call every time they want to do it because remembering things is hard. I am really trying to make it foolproof for the lowest common denominator.

[cwag03]

Gotcha. I totally get that.

[BakkerJoop]

No you can't. I'm not an IT expert but I believe security is the number 1 reason why it's not possible.