Forum Discussion

MF_Wong's avatar
MF_Wong
Regular Visitor
8 years ago
Solved

Export Data fails when connected to SSAS live

I have been using Power BI Desktop to have SSAS live connection. It is such a great experience as the speed of getting data is really high and I can use that as a way to "Export Data" up to 30,000 ro...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi MF_Wong,

     

    According to this article, there is currently a limitation that export using Underlying data will not work if the data source is an Analysis Services live connection and the version is older than 2016 and the tables in the model do not have a unique key. :smileyhappy:

     

    Regards

kevhav's avatar
kevhav
Icon for Continued Contributor rankContinued Contributor
8 years ago

We may have just encountered this same issue.

 

I'm not using the SSAS live connection; but I am using the "Power BI service" live connection, which I understand uses similar technology.

 

This happens only when we (myself and other users in my organization)  export data from one particular Matrix visualization. The result set is quite small, but still, Power BI Desktop give the warning like "data size is too large; some sampling may occur." When I open the resulting .CSV file in Excel, only cell A1 has contents, and the contents are...



... MF_Wong, is this what you mean when you say "a strange symbol appears?" (The resulting .CSV file is blank, when I open it in Notepad.)

 

I've published this report to the Power BI service, and we are also unable to "Export Data" from the service. When we try, the dialog appears and spins for ~1 minute, but then it disappears and nothing happens (no file is downloaded). 

 

Most reports/visualizations are unaffected. But with this one visualization where we are experiencing the issue, it might be a problem with a particular measure. If I remove this one measure from the Matrix visualization, then "Export Data" works as expected.

 

Or, interestingly, if I change the visualization type from Matrix to Table...even with that measure still included...then again, "Export Data" works as expected.

 

So, for me, I only experience this issue when I am using a Matrix-type visualization that has this one particular measure. Very weird.

MF_Wong's avatar
MF_Wong
Regular Visitor
8 years ago

... @MF_Wong, is this what you mean when you say "a strange symbol appears?" (The resulting .CSV file is blank, when I open it in Notepad.)

 

kevhavYes.  That's excatly what happened in my case.  Thanks for your detailed description.

 

Im my case, no matter it is a visual, a matrix, or a table... Export data doesn't work.  :(