Power BI report Builder power query generating null values with desktop report datasets

[psingh94]

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!

[mkujalowicz]

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

[mkujalowicz]

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

[psingh94 · Accepted 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

[AbhiSSRS]

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/

[v-xulin-mstf]

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.

[psingh94]

Hi Link,

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

Thanks,

Punar

[v-xulin-mstf]

Hi @psingh94

You can link directly to the dataset as:

You can refer:

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

Best Regards,

Link

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