Forum Discussion
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
- scott_hendersonHelper II
Scheduled Refresh for a certain time ? Or can you use power automate ?
- bingenRegular Visitor
Here it should appear another option called Page Refresh, but I don't know why it doesn`t
- scott_hendersonHelper 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.- bingenRegular Visitor
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_hendersonHelper II
Is it published to a workspace or "My Workspace" ? What type of licence do you have ?
- bingenRegular Visitor
It is published to My Workspace and I have the pro licence (On trial).
- scott_hendersonHelper 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.
- bingenRegular Visitor
Ok, I will try
- bingenRegular Visitor
I`ve tried it but it still gives the same error.
- bingenRegular Visitor
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
- scott_hendersonHelper II
Can you refresh in desktop ?
Can you also confirmed you created a new "Pro" workspace in service ?- bingenRegular Visitor
Yes, I can refresh in Power BI desktop, but not in Power BI service.
And I created a new workspace.
- scott_hendersonHelper II
can you expand the view detials on the error message please.
- bingenRegular Visitor
- scott_hendersonHelper II
Unsuppoted data source, can you screen me the model and confirm what each source is ?
- bingenRegular Visitor
The Data is a csv on Amazon S3, and I use a python script to extract that data.
- scott_hendersonHelper 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 ?
- bingenRegular Visitor
this is the model screen
- scott_hendersonHelper II
Can you screen lineage view in pbi service ?