Schedule Refresh failed

[mb0307]

Hi,

I am unable to schedule report refresh (Power BI services), the error message i get is:

"You can't schedule refresh for this dataset because the following data sources currently don't support refresh":

My report is pulling data from a website by passing credentials as parameter.  Report will call 3 APIs.

Authentication API shows this:

let
   Source = Xml.Tables(
Web.Contents("https://" & #"Server Name" & "/rest/2/authentication/createSession?accountID=" & #"Account Name" & "&user=" & Login & "&password=" & Password,
[Headers=[#"Content-type"="application/x-www-form-urlencoded"],
Content=Text.ToBinary("")])),
   authResponse = Source{0}[authResponse],
   #"Changed Type" = Table.TransformColumnTypes(authResponse,{{"sessionID", type text}}),
   sessionID = #"Changed Type"{0}[sessionID]
in
   sessionID

I am trying to get two datasets Order and Route from a website using API.

Any help will be much appreciated.

Thanks

[v-diye-msft · Accepted solution]

Hi @mb0307 

 You will need to find the data source that you are using and compare that against the list of supported data sources at Refresh data in Power BI.

1. In Power BI Desktop, make sure you are on the Report pane.

2. Select Edit Queries from the ribbon bar.

3. Select Advanced Editor.

4. Make note of the provider listed for the source. In this example, the provider is ActiveDirectory.

5. Compare the provider with the list of supported data sources found in Power BI data sources.

For refresh issues related to dynamic data sources, including data sources that include hand-authored queries, see refresh and dynamic data sources.

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".