Gateway is running, credentials are updated.
Sources: mix of on-prem analysis service, dataflows and sharepoint files.
Desktop updates without issues.
Both scheduled jobs and "refresh now" in the services gives the above error?
What to do?
@SFrost I'm also getting this error while refreshing the report in PowerBI service. When I remove one particular dataset from the report, it refreshes successfully in service. I do not know what is causing the issue in service.
I upgraded gateway but it doen't work. When I remove and add back the data set to the report without transformations, it refreshes in service. When I bring back transformations like append query etc.. it fails in the service.
Do you mean you have created a report and mix sharepoint online files and SSAS in a dataflow entity, right? Have you also configured the credentials in gateway settings for the sharepoint online files? In addtion, have you update on premises data gateway to the latest version?
If this issue still persists, please enable the additional log and share part of the tracing log for further analysis. Make sure you have removed all sensitive data in the tracing log before you post.
We are also getting this on a couple of our pbix files. I have tracked it down to an "Append Queries" step in power query. If I remove the step it refreshes. The ones failing are the ones appending SSAS data and the ones that seem to work are the SQL to SSAS appends I think. I do have an open ticket for these.
It started happening on the 30th August.
I have similar problems with some of our reports (mix sql /SSAS + files), and also we use "Append Queries". Our problems started 30th August, earlier everything was fine. We have problem also with "Merge Queries". The queries looks like:1step - import csv file2step - merge queries (SSAS source)3step - expand4step - merge queries (Another SSAS source)5step - expand
Have the same issue, SSAS and other sources combining through append.
Same for me, exactly from same dateDoes somebody know if they are trying to fix it? Will they let us know when fixed?
The same case:
Sources: mix of on-prem analysis service and sharepoint files.
@lmiranda my case is still open and I think they are still looking into it. If you have a pro license you could also open a support ticket.
Hello, we have a same issue with one of our reports using on-premise SSAS connection. Works fine from Power BI Desktop.
You could check the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/IssuesAnd if it is not there, then you could post it.If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.