Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using desktop report as a data source in my power BI report builder.
One of the datasets in the desktop report has its data source as azure analysis services databases. I have used import data rather than live connection as I had to perform data modeling in the desktop report. And to filter the data I had written MDX query as data source.
Now, in the report builder query generator, I am getting null values for that table.
I have also added the connection to azure analysis services databases in report builder. But still not getting the data.
Any help would be appreciated.
Thanks!
Solved! Go to Solution.
I followed the following steps and got the data. It was also more relevant as the logics to create the visualizations got translated as well.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets
I think I have jsut found a solution to this problem, as I have reproduced all the steps above and I still kept seeing null values.
So whenever you are in the Query Designer, try to change the query "language" from DAX to MDX.
I hope it helps
I think I have jsut found a solution to this problem, as I have reproduced all the steps above and I still kept seeing null values.
So whenever you are in the Query Designer, try to change the query "language" from DAX to MDX.
Not sure why my query language should be MDX, but at least in my case it worked.
I hope it helps
I followed the following steps and got the data. It was also more relevant as the logics to create the visualizations got translated as well.
https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets
While this is strange that you dont see data, using a power BI data source of a live connected report isn't optimal, you may use the original source on paginated report for better connectivity(faster too)
Also if you wish to still use the power Bi dataset, please try connecting to it using the "Add datasource" ,
paste in the power Bi dataset connection string in servername and use that to connect.
Also you can do your development locally using a method in below article :
https://www.linkedin.com/pulse/build-paginated-local-power-bi-desktop-dataset-abhinav-singh/
Hi @psingh94,
Does the data show well in power bi desktop?
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Link,
yes, the data is coming up in the desktop report.
Thanks,
Punar
Hi @psingh94
You can link directly to the dataset as:
You can refer:
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.