Forum Discussion
Refresh time
Hi Richard76
The below will help you to get better performance on load, "Remove useless columns" and "Split date and time" probably most relevant here.
https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/
If you want to understand what happens when you load the data, please read the below.
https://www.microsoftpressstore.com/articles/article.aspx?p=2449192&seqNum=3
A lot of other factors has importance too, like.
- Does it happen in PBI Service or Desktop
- Where is the data source located vs where is the service located
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Hi Richard76
The below will help you to get better performance on load, "Remove useless columns" and "Split date and time" probably most relevant here.
https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/
If you want to understand what happens when you load the data, please read the below.
https://www.microsoftpressstore.com/articles/article.aspx?p=2449192&seqNum=3
A lot of other factors has importance too, like.
- Does it happen in PBI Service or Desktop
- Where is the data source located vs where is the service located
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.