Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
If my Power BI desktop file is updated with new data from my data source (in this case a CSV file), do I always need to publish it so that my online dashboard (on web app) reflects the new data?
Is there a way for the online dashboard to automatically display the updated data?
Thanks!
Solved! Go to Solution.
@afk,
You can configure Power BI gateway on your machine, add the csv data source within the gateway, then set schedule refresh for your dataset in Power BI Service. This way, when data are changed in the csv file, the data will be automatically updated in Power BI Service, and you don't need to re-publish PBIX file each time.
Regards,
Lydia
You can also have the .csv file placed in a onedrive folder and change the url in Power BI - Edit Queries on file source properties.
Here is a instruction:https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
@v-yuezhe-msft solution is also an option but it requires the computer with the gateway to always be online when the update is made.
@afk,
You can configure Power BI gateway on your machine, add the csv data source within the gateway, then set schedule refresh for your dataset in Power BI Service. This way, when data are changed in the csv file, the data will be automatically updated in Power BI Service, and you don't need to re-publish PBIX file each time.
Regards,
Lydia
You can also have the .csv file placed in a onedrive folder and change the url in Power BI - Edit Queries on file source properties.
Here is a instruction:https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links
@v-yuezhe-msft solution is also an option but it requires the computer with the gateway to always be online when the update is made.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.