Forum Discussion

Tsanka's avatar
Tsanka
Kudo Collector
5 years ago
Solved

Creating paginated report with PowerBI datasource

Hi guys,

 

I am creating paginated reports with a PowerBi datasource.

 

The process is extremely slow. Opening the query designer, defining the parameters, executing the DAX take ages. When using the Power BI Desktop with the same Power BI dataset the performance is fine.

 

 Is there something that I can do to speed up the Report Builder when using Power BI dataset?

 

Thanks

Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    You already provided the answer. Work with the dataset copy that is provided by your local Power BI desktop (make sure desktop is running, use DAX Studio to infer the port number etc) and then when you are finished with your development work switch your datasource to the cloud dataset.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    You already provided the answer. Work with the dataset copy that is provided by your local Power BI desktop (make sure desktop is running, use DAX Studio to infer the port number etc) and then when you are finished with your development work switch your datasource to the cloud dataset.

    • Tsanka's avatar
      Tsanka
      Kudo Collector
      5 years ago

      Thanks, I was hoping there was an easier way as getting the pbix file is sometimes impossible (when working in a corporate enviroment)