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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Solution Authors