Forum Discussion
Mixed Data in semantic model
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,
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.