Forum Discussion
Theoretical questions
vnicholl So, the recommendation would be to use a single dataset and use Live connections to that dataset. This way all reports would have all of the measures available within the dataset. The way to cut down refresh times would be to implement incremental refresh.
vnicholl So, the recommendation would be to use a single dataset and use Live connections to that dataset. This way all reports would have all of the measures available within the dataset. The way to cut down refresh times would be to implement incremental refresh.
So you are saying we would need to add to that table the extra fields? Basically remove it from PowerBI and put it on the backend?
How would we do an incremental refresh? We refresh or recreate our tables every night. Or is there another way to do so in Power BI?
Thanks.
vnicholl Right, so add all your measures and columns into a central "golden" dataset. Use a Power BI dataset connection (Live connection) from other PBIX files. This might help: Power BI Usage Models in Pictures! - Microsoft Power BI Community. Also, Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Docs
Incremental refresh allows you to refresh only new and changed data. Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
