Forum Discussion
Dataset refresh timeout
Hi SteffenH82
I would recommend preparing the data as much as possible at the source. Power Query is powerful, but many transformations on big datasets can cause these issues. When connecting to the Database, you can use the Advanced Options to set a timeoutYou will be probably aware, but I will mention it anyway. Try and keep the transaction tables as slim as possible, only have ids, dates etc in these tables. If the employee table has Date/Time columns, if you don't need the time, then convert to date only. If you do need the time, create a separate column for the time part. The more cardinality in the columns the faster the load. Move all teh information like products, employee, date, time infomation etc.. to dimension tables. More info here
In the options section of Power BI Desktop, you can set some settings to help with loading times. Turn off Time intelligence if you are using a date table.
Hope these tips help
Joe
Solution SageHi SteffenH82
I would recommend preparing the data as much as possible at the source. Power Query is powerful, but many transformations on big datasets can cause these issues. When connecting to the Database, you can use the Advanced Options to set a timeout
You will be probably aware, but I will mention it anyway. Try and keep the transaction tables as slim as possible, only have ids, dates etc in these tables. If the employee table has Date/Time columns, if you don't need the time, then convert to date only. If you do need the time, create a separate column for the time part. The more cardinality in the columns the faster the load. Move all teh information like products, employee, date, time infomation etc.. to dimension tables. More info here
In the options section of Power BI Desktop, you can set some settings to help with loading times. Turn off Time intelligence if you are using a date table.
Hope these tips help
Joe