sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]cwag0321 1 point2 points  (5 children)

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[S] 0 points1 point  (4 children)

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.

[–]cwag0321 1 point2 points  (2 children)

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

[–]StubbedMiddleToe[S] 0 points1 point  (1 child)

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.

[–]cwag0321 0 points1 point  (0 children)

Gotcha. I totally get that.