Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
4 years ago
Solved

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...
Need Help
  • ibarrau's avatar
    ibarrau
    4 years ago

    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,

ibarrau's avatar
ibarrau
Super User
4 years ago

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,

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
4 years ago

Thanks ibarrau 
This challenge has caused be so many problems and you solved it with such an easy fix.
I really appreciate it.