Forum Discussion
Mixed Data in semantic model
I have a semantic model with direct query access to SSAS tables and Dax tables creates from the SSAS data and imported data from csv files.
when I published the semantic model to power bi service I get the message when I try refreshing the model
The semantic model contains calculated tables or calculated column that refer to remote table, which will result in refresh failures after publicaton if the dataset is not configured to use explicit connection with granular access control to access this data source.
how do I fix this issue.
Hi Anonymous,
Thanks for posting your query in Microsoft fabric community forum.
If your Power BI dataset relies on calculated tables or columns pulling data from an SSAS server, regular refreshes won’t work without proper setup. Here’s how to fix it:- Install and configure a gateway to connect Power BI to your on-premises SSAS server. In the gateway settings, add SSAS as a data source with the server name, database, and credentials. Use an account with minimal necessary permissions (granular access control).
- In Power BI Desktop, review calculated tables/columns referencing SSAS, especially DAX functions like RELATEDTABLE, LOOKUPVALUE, or CALCULATE.
- After publishing your dataset, ensure it connects to the correct gateway and data source in Power BI service settings.
Republish the dataset, verify data source credentials in Power BI service, and refresh. It should work if everything’s set correctly.
If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.
5 Replies
They want you to use credential passthrough for the SSAS connections, I think.
Hi Anonymous,
Thanks for posting your query in Microsoft fabric community forum.
If your Power BI dataset relies on calculated tables or columns pulling data from an SSAS server, regular refreshes won’t work without proper setup. Here’s how to fix it:- Install and configure a gateway to connect Power BI to your on-premises SSAS server. In the gateway settings, add SSAS as a data source with the server name, database, and credentials. Use an account with minimal necessary permissions (granular access control).
- In Power BI Desktop, review calculated tables/columns referencing SSAS, especially DAX functions like RELATEDTABLE, LOOKUPVALUE, or CALCULATE.
- After publishing your dataset, ensure it connects to the correct gateway and data source in Power BI service settings.
Republish the dataset, verify data source credentials in Power BI service, and refresh. It should work if everything’s set correctly.
If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.Hi Anonymous,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
Hi Anonymous,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Anonymous,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
