Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I prepared a report on Power bi desktop that imports data from an SQL analysis services database, filtered with an MDX query as the amount of the data is huge. Everything works fine.
When I publish the report to the Power BI service and after the first refresh of the data, the data don't seem to be right. It seems as if the MDX query is not applied.
Is this by design?
Thanks,
I
I am having the same problem. Using import mode with MDX from an On-Premsises Tabular model.
In Power BI Desktop, it resfreshes.
In Power BI Services, through the gateway, it says that it refreshes but it doesn't display the new data. I run SQL Server Profiler and the query gets to Analysis Services On-Premis es but the information doesn't come back to Power BI Services. I don't see any errors in the GW logs.
I am extending the information:
Hi @ibanio
When you publish report to Power BI Server, you need configure gateway for the dataset.
Please follow the reference below.
Manage your data source - Analysis Services
If this link doesn't help, please hsow more details:
"SQL analysis services database, filtered with an MDX query"
This means you write SQL statement in the box when importing to Power BI Desktop,right?
When you refresh data, have you ever change the parameter in this SQL statement?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response Maggie.
I use a personal gateway, not enterprise so there is not much to be configured. Looking on the refresh history I can see that the data refresh works.
You are right, I wrote an MDX query in the box when importing data to Power Bi desktop and it works fine. On the Power BI service the query is not applied.
I don't use parameters.