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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
bingen
Regular Visitor

Automatically refresh a report in Power BI

I'm importing data to power bi through a python script where I get the data from an amazon api but it don't let me schedule its update. 

 

Can anyone help me?

 

19 REPLIES 19
scott_henderson
Helper II
Helper II

This is fine, but can you screen the model in power bi desktop, and confirm any other sources ?

If you go to the workspace does it have the credentials required ?  No issues or errors ?

scott_henderson_0-1682084084582.png

 



bingen_0-1682084448610.png

this is the model screen

Can you screen lineage view in pbi service ?

 

scott_henderson
Helper II
Helper II

Unsuppoted data source, can you screen me the model and confirm what each source is ?

 

The Data is a csv on Amazon S3, and I use a python script to extract that data.

scott_henderson
Helper II
Helper II

can you expand the view detials on the error message please.

 

bingen_0-1682083205908.png

 

scott_henderson
Helper II
Helper II

Can you refresh in desktop ?

Can you also confirmed you created a new "Pro" workspace in service ?

Yes, I can refresh in Power BI desktop, but not in Power BI service. 

 

And I created a new workspace.

scott_henderson
Helper II
Helper II

I'd suggest create a new workspace, publish there and try again, I don't think "My Workspace" allows scheduled refresh from what I remember.

 

bingen_0-1682078908930.png

 

I think I have found where the error is, but i don´t know how to solve. In power BI desktop I update and it detects it, but when I click update in power BI service an error occurs, without updating

 

 

I`ve tried it but it still gives the same error. 

Ok, I will try

scott_henderson
Helper II
Helper II

Is it published to a workspace or "My Workspace" ?  What type of licence do you have ?

 

It is published to My Workspace and I have the pro licence (On trial).

scott_henderson
Helper II
Helper II

You set scheduled refresh in service, not in desktop....

Go to the workspace where the dataset is published, click the settings, then Scheduled Refresh. 

bingen_0-1682074907543.png

 

There I get that error.

 

"You cannot schedule refresh  for this dataset because the following data sources do not support refresh:  Query1 data source" 

scott_henderson
Helper II
Helper II

Scheduled Refresh for a certain time ?  Or can you use power automate ?

scott_henderson_0-1682074095530.png

 

bingen_0-1682074350799.png

Here it should appear another option called Page Refresh, but I don't know why it doesn`t

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.