Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

Power BI Desktop to Report Builder

Hello,    Im trying to get some of my Power BI Desktop into a Paginated Power BI Report Builder file.   I used my Power BI service Dataset Connection along with the Performance Analyzer DAX metho...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi amandabus21 ,

Please don't paste the above query into Expression area directly, you can follow the steps in the following official documentation to do it.

Create the dataset with the query

1. Right-click the dataset under Data Sources and select Add Dataset

2. In Dataset Properties, give it a name, and select Query Designer.

3. Make sure DAX is selected, and deselect the Design Mode icon. In the upper box, paste the above DAX Query in your post.

Best Regards

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper V
3 years ago

hi Anonymous 

When I do it this way, and I run the report, it stays loading for a very long time and never actually provides a result.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi amandabus21 ,

    Please check if you hit any following limitation, you can find more details in this official documentation...

    If the above one is OK, could you please provide the following information for further troubleshooting?

    1. Whether the above DAX query can load the data in Power BI Desktop? Is it large?

    2. Provide the screenshot of your Performance Analyzer with the detailed steps?

    3. Share some raw data of involved tables in the above DAX query and backend logic 

    Best Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  amandabus21 ,

    Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

    Best Regards