Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

SFrost

OnPremise error: Sorry, something went wrong - has anyone seen this before?

Submitted by on ‎08-31-2020 12:12 PM

Hi, 

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?

Status: New
14 Comments (14 New)
Comments
Anonymous
Not applicable
‎09-01-2020 01:16 AM

@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.

v-yuta-msft
Community Support
Community Support
‎09-01-2020 01:26 AM

@SFrost ,

 

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.

 

Regards,

Jimmy Tao

gooranga1
Power Participant
Power Participant
‎09-02-2020 04:21 AM

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.

 

.

Msta
Helper I
Helper I
‎09-02-2020 10:09 PM

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 file
2step - merge queries (SSAS source)
3step - expand
4step - merge queries (Another SSAS source)
5step - expand

MarkShu
Helper I
Helper I
‎09-06-2020 10:37 AM

Have the same issue, SSAS and other sources combining through append.

lmiranda
Regular Visitor
‎09-07-2020 05:01 AM

Same for me, exactly from same date
Does somebody know if they are trying to fix it? Will they let us know when fixed?

Thanks

gosia_szwarc
Regular Visitor
‎09-08-2020 05:49 AM

The same case:

Gateway is running, credentials are updated. 

Sources: mix of on-prem analysis service and sharepoint files.

Desktop updates without issues.

Both scheduled jobs and "refresh now" in the services gives the above error?

gooranga1
Power Participant
Power Participant
‎09-14-2020 06:28 AM

@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.

Anonymous
Not applicable
‎09-22-2020 05:47 PM

Hello, we have a same issue with one of our reports using on-premise SSAS connection. Works fine from Power BI Desktop.

 

Thanks

Greg_Deckler
Super User
Super User
‎09-22-2020 05:52 PM

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And 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".

Idea Statuses