Forum Discussion
Only automate updates from some data source
Hi Power BI community
I want get data from a CSV file and publish it to the power bi serivce
I only really need to get the data from the CSV file once, but to get the automatic updates from my My.SQL server it seems like I need to get data from the sorce everytime.
Is there a way to disable a single data source when I set my automated update or do I have to check all the data sources each time?
Hi Thomas. You do two things. If the csv will never refresh you can enter the data manual to keep it static. The second and best approach is loading the csv at PBI Desktop and uncheck the item for including in the refresh at the Query Editor:
Once you uncheck that it won't be part of the refresh at service and it will remain static.
I hope that helps,
2 Replies
Hi Thomas. You do two things. If the csv will never refresh you can enter the data manual to keep it static. The second and best approach is loading the csv at PBI Desktop and uncheck the item for including in the refresh at the Query Editor:
Once you uncheck that it won't be part of the refresh at service and it will remain static.
I hope that helps,
Thanks ibarrau
This challenge has caused be so many problems and you solved it with such an easy fix.
I really appreciate it.
