Forum Discussion
Power BI report Builder power query generating null values with desktop report datasets
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!
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
7 Replies
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
- v-xulin-mstf
Community Support
Hi Anonymous,
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.
- v-xulin-mstf
Hi Anonymous
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.
- AbhiSSRS
Solution Sage
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/
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 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
