Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

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.

psingh94_1-1619197595289.png

 

 

Now, in the report builder query generator, I am getting null values for that table.

psingh94_0-1619197389607.png

 

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!

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

7 REPLIES 7
mkujalowicz
Frequent Visitor

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.

mkujalowicz_0-1673976146633.png

I hope it helps

mkujalowicz
Frequent Visitor

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.

mkujalowicz_0-1673976146633.png

I hope it helps

Anonymous
Not applicable

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

AbhiSSRS
Solution Sage
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.

 

AbhiSSRS_0-1619512513171.png

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/

v-xulin-mstf
Community Support
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.

Anonymous
Not applicable

Hi Link,

 

yes, the data is coming up in the desktop report.

 

Thanks,

Punar

Hi @Anonymous

 

You can link directly to the dataset as:

v-xulin-mstf_0-1619508693412.jpeg

You can refer:

https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-power-bi-report-builder-part-1-importing-data

 

Best Regards,

Link

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.