POwerBI Service refresh failing whereas desktop refresh working fine

[Ananymous]

Hello,

Could someone help on how to fix this error while refreshing powerbi dashboard from service am getting this error where as refreshing through desktop is working fine. I verified all the data credentials are correct, connected to the server and no errors with credentials or with gateway connectivity. 

Data source error: {"error": {"code": "SSAS_ShortMessage_ProcessingError","pbi.error": {"code": "SSAS_ShortMessage_ProcessingError","parameters": {},"details": [],"exceptionCulprit": 1}}} Cluster URI: WABI-NORTH-EUROPE-H-PRIMARY-redirect.analysis.windows.net Activity ID: e6cf9229-c597-46e3-923e-79599a952cd1 Request ID: 3188b094-816b-4560-abdd-05d936da84d5 Time: 2025-11-03 14:19:01Z

[Ananymous · Accepted solution]

Thank you all @tayloramy  @sergej_og , @anilgavhane for actively engaging on my query. Really appreciated. The final thing I did is using measures in the Jira table insterad of outer join sharepoint table into Jira table. And now the refresh is working. Few more insights that i learnt are it could be also ran out of memory issue of my laptop as well. This morning I refreshed the latop and retried to refresh board in powerbi Service, it worked finally. Putting it here if it helps any community members. Thanks again and have a great time ahead. 

[Ananymous]

Hi @anilgavhane , 

I tried some of these steps (suggested by copilot too) , none of them helped to fix the issue unfortunately. And I must use only personal gateway because I dont have any standard gateway. Large DAX queries exceeds memory limits, what I tried differently to avoid outer join is I removed the merging in the table and built separate measures to achieve what I want but still I am not getting out of the error. 

[Natalie_iTalent]

Hello @Ananymous,

The comment you were responding to has been removed due to inaccurate AI generated content.

Best,

Natalie H.

Community Manager 

[Ananymous]

Hi @tayloramy , 

 Yes, am using on-prem gateway in personal mode and it was working well until last week, this week I made a change to include outer joins and I suspect that must be the culprit. And am wondering if thats the culprit, why is it working in desktop and failing in service. My data source is sharepoint, one drive and Jira. 

[tayloramy]

HI @Ananymous, 

Can you verify that your personal gateway is online and working? FOr anything outside of testing, a standard gateway installed on a server that doesn't turn off when you turn off your computer for the night is recommended. 

Can you provide more details on the errors? Are there any error messages you can share about these joins? 

If you refresh in Power BI Desktop are there any problems there? 

In the service have you configured the required connections to SharePoint, OneDrive, and JIRA on your personal gateway? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[Ananymous]

Hi @tayloramy ,

As I suspected, the issue is with outerjoin, when I try to refresh board in powerBI service without the outerjoin step then it works fine. The logic am using for outer join is merging sharepoint source data file into Jira source data file and thats where its failing to refresh in powerBI service where as refresh works fine in desktop. 

[sergej_og]

Hey @Ananymous 
we had something similar in the past while merging two different sources. One of them was Sharepoint.
If I remember right the root couse was the Privacy Level of the sources. Maybe your sources have a "strage" combination for Service. Sharepoint as "private" and JIRA as "organizational".
You can set it up in your .pbix and in the Gateway connection itself in Service.
Give it trial if you want. Play a bit around.

Regards

[Ananymous]

Hi @sergej_og , 

Its a nice clue, I had similar in the past too and its not the case for current issue. All data sources are set to same privacy settings. The rootcause is really outer join login where am refeering 6 entries in sharepoint data table and calculating a factor in jira data table(which has ~1000 rows data) so am guessing its failing with it. So I tried to removing the merging in the table and built separate measures to achieve what I want but still I am not getting out of the error. Its getting more and more interesting. 

[sergej_og]

Hey @Ananymous 
another similar case I had in the past...I resolved it by splitting the data sources into different entities - like bringing the issue causing source to a dataflow. Then get the data from dataflow into your model and combine them.

What do you think?

Regards

[Ananymous]

Hi @sergej_og , 

Thats a good idea, thanks for thinking about it. Unfortunately I cannot use dataflows (as the workspace am using is "my workspace") and I cannot publish it to any other workspaces.

[tayloramy]

Hi @Ananymous, 

That's interesting. Are you able to detail what you did in the outer join? I wonder if we can replicate it. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[Ananymous]

@tayloramy 

In my outerjoin logic, am refeering 6 entries in sharepoint data table where Team and PI combinations are unique and calculating a factor in jira data table(which has ~1000 rows data with Team and PI combinations). For example Team XX and PI 1 in sharepoint file has factor 2, then I look for Team XX and PI 1 combination in Jira features table and join a new column as Factor with value 2. And powerBI service refresh is failing with this logic which I think is due to memory limit. So I tried by removing the outer join in the table and added separate measures in Jira table to achieve what I want but still I am not getting out from the error 😞 

[tayloramy]

Hi @Ananymous, 

Can you provide some more details? 

What is the data source? Are you using an on prem gateway?

Desktop uses a different context for the refresh, did you set up all the connections properly in the service after publishing? 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.