cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft shhafiz
Microsoft

Upload Static CSV and do not Refresh

I am working with a cloud data source and I have created a static CSV file to support the queries which I uploaded from my local machine using PowerBI desktop. Unfortunately, the data being local to my machine fails to refresh. I do not need this file to refresh as the contents are static. How can I upload this file from Power BI desktop and not have it auto refresh.

 

I am already aware of couple of solutions:

 

1) Host the CSV in cloud, such as One Drive

2) Use Power BI gateway for files local to working computer.

 

Since I do not need any refresh of the data, is there a different way to do this istead of engaging external data sources?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Upload Static CSV and do not Refresh

@shhafiz,

Based on your description, you want to configure schedule refresh for another dataset. If you connect to on-premises data sources in this dataset, you should firstly add all the data sources within on-premises gateway, then go to Settings->Datasets and find your dataset in Power BI Service, you will be able to schedule refresh for that dataset.

If you still have questions about refresh, please post the screenshot about your scenario, we need to know the data sources contained in your dataset.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: Upload Static CSV and do not Refresh

@shhafiz,

I am not very clear about your scenario. Do you connect to local CSV file in Power BI Desktop, create report in Power BI Desktop and publish the report to Power BI Service? If that is the case, as long as you don't set schedule refresh for your dataset in Service, the dataset will not be automatically refreshed.

And if you still have questions about refresh in Power BI, please post screenshots about your scenario so that we can provide you better suggestions.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft shhafiz
Microsoft

Re: Upload Static CSV and do not Refresh

@v-yuezhe-msft

 

Yes, you have described my scenario correctly. The problem is I have another dataset which is set for scheduled refresh. My anticipation was, when I publish to Power Bi service after connecting to local file, it would show up somewhere in the Web view and I should be able to configure it. Unfortunately, I do not see it listed anywhere. 

 

How can I configure the settings to refresh the other data source but not the one connected from local machine.

 

Thanks.

 

 

Moderator v-yuezhe-msft
Moderator

Re: Upload Static CSV and do not Refresh

@shhafiz,

Based on your description, you want to configure schedule refresh for another dataset. If you connect to on-premises data sources in this dataset, you should firstly add all the data sources within on-premises gateway, then go to Settings->Datasets and find your dataset in Power BI Service, you will be able to schedule refresh for that dataset.

If you still have questions about refresh, please post the screenshot about your scenario, we need to know the data sources contained in your dataset.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors