Forum Discussion
Power BI dataset refresh error
Hi. There are a lot of good posts and videos about downsizing a Power Bi Dataset. I think there are three very important tips that might help a lot:
- Do data model: building a good star schema instead of loading tables is an amazing way to start a model with it's minimun size.
- Remove unnecessary columns: keeping your model with the data you need is one of the best ways to maintain it the smaller you can.
- Turn auto datetime off: turning of this power bi desktop feature can reduce a lot the size of the model because it creates a hidden table for each date or datetime column in the model. You should build and work with your own date/calendar table.
You can check more about this in microsoft doc: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Or even in some nice videos from guyinacube:
https://www.youtube.com/watch?v=RnDdDlozcdo
https://www.youtube.com/watch?v=qZOEDBedATA
I hope that helps,
Hi,
I have tried to rename the pbix file and published in Power BI service and scheduled the refresh as you suggested. But this time I am facing another error as shown in below screenshot.
Any suggetions to break up the dataset into smaller datasets?
Hi. There are a lot of good posts and videos about downsizing a Power Bi Dataset. I think there are three very important tips that might help a lot:
- Do data model: building a good star schema instead of loading tables is an amazing way to start a model with it's minimun size.
- Remove unnecessary columns: keeping your model with the data you need is one of the best ways to maintain it the smaller you can.
- Turn auto datetime off: turning of this power bi desktop feature can reduce a lot the size of the model because it creates a hidden table for each date or datetime column in the model. You should build and work with your own date/calendar table.
You can check more about this in microsoft doc: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Or even in some nice videos from guyinacube:
https://www.youtube.com/watch?v=RnDdDlozcdo
https://www.youtube.com/watch?v=qZOEDBedATA
I hope that helps,