Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    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.

v-ssriganesh's avatar
v-ssriganesh
Community Support
1 year ago

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.