Finding the best Data Source in Power BI – Part VI
If you haven’t already, make sure to start with Part I – V where I explore OneDrive, Live Connect, Dataverse, SQL Server, and DataFlow and set the baseline on how to measure “best” connector type in Power BI.
Part I- https://bilingualanalytics.com.au/data-connectors-onedrive/
Part II- https://bilingualanalytics.com.au/data-connectors-live-connect-power-bi-dataset
Part III – https://bilingualanalytics.com.au/data-connectors-dataverse/
Part IV – https://bilingualanalytics.com.au/data-connectors-sql-database/
Part V – https://bilingualanalytics.com.au/data-connectors-dataflow/
While CSV files would be considered Excel files, they are not the same as XLSX files.
A viewer asked a question about which extension could provide better refresh speeds. Honestly, I haven’t thought about that question before, so the only option I had was to test it.
It turns out there are significant differences when it comes to Power BI report refresh speed.
If you want to see how much, make sure to check the video below and decide for yourself if switching to importing CSV files is something that you want to explore.
Roland
🙏Thanks for watching and if you liked this video please hit the 👍 button.
📢 Also be sure to subscribe to the channel so you never miss a new video.
0 Comments