Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
keobrie
Helper I
Helper I

Data Refresh in Service doesn't work but Desktop Does

This question is extremely simple and I'm sure its just that I've never done this before.  I have a series of Power BI reports that I built using Power BI Desktop.  The data model consists of two files refreshed from URLs:

AzureBlob{"url":"https://usafactsstatic.blob.core.windows.net/public/data/covid-19/covid_confirmed_usafacts.csv"}
AzureBlob{"url":"https://usafactsstatic.blob.core.windows.net/public/data/covid-19/covid_deaths_usafacts.csv"}

 

Then, I innocently imported about 5 CSV files from my local machine to provide reference table lookups (convert zip codes, State names, etc. ... pretty basic stuff).  I unchecked "Include in report refresh" on all the local CSV files because they don't change.  The desktop has been refreshing the two URL based CSVs above without a problem.  

 

I've published the reports to the Power BI Service (Power BI Pro) with the intent to have the data automatically refresh daily on an unattended basis.  This set of reports were more of a hobby but I like having the ability to show the reports on my mobile devices from time to time.

 

Anyway, the dataset won't refresh in the service.  Its prompting me for a Gateway which shouldn't be necessary for the URL's above.  I don't want to go back and rebuild everything from scratch but I will if necessary.

 

I just tested a "dataset only" deployment stripping out all of the visualizations and removing all of the data sources other than the two above.  Once published, I was prompted for credentials, set the credentials to anonymous and the Privacy Level to "none" and the dataset appears to be functioning properly.

 

Can somebody tell me what I did wrong and how I should do this to have it work properly (ie. update the two URL based CSVs on an unattended basis in the service).

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

HI @keobrie 

 

The reason is because you imported the CSV files, Power BI wants to refresh those same CSV files.

 

What you can do as a workaround is instead of importing the CSV files, click on ENTER Data and copy and paste the contents from your CSV files into the ENTER data screen.


By doing this, no data is actually imported from a CSV file, but rather pasted into your Power BI desktop file.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
v-xiaoyan-msft
Community Support
Community Support

Hi@keobrie

 

It's pleasant if your problem has been solved, could you please mark the reply as Answered? that way, other community members will easily find the solution when they get the same issue.

 

 

Hope it helps.

 

Best Regards,
Caitlyn Yan

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

GilbertQ
Super User
Super User

HI @keobrie 

 

The reason is because you imported the CSV files, Power BI wants to refresh those same CSV files.

 

What you can do as a workaround is instead of importing the CSV files, click on ENTER Data and copy and paste the contents from your CSV files into the ENTER data screen.


By doing this, no data is actually imported from a CSV file, but rather pasted into your Power BI desktop file.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors