Forum Discussion
Slow performance directquery to Power BI Dataset
Hi all, i am importing data from a csv file into PBI Desktop and publishing it to our premium workspace. The report is blank, and we use it as a shared Power BI Dataset. This will have roughly 50...
In this instance there are two pbix files being created. The first is an import from a csv and is published to premium workspace to be used later as a Power BI Dataset. If i made a report on this file it actually runs quite quick.
The second pbix file connects to the above Power BI Dataset as its source and we create dashboards which are against published to the workspace. This connection is done over directquery and is far slower to refresh the page when we click around.
The idea is for lots of different people to be able to make their own dashboards from the same dataset.