data refresh not supported? - Sharepoint

[augustindelaf]

Hi, 

using Power BI desktop, I made a series of requests to excel files on sharepoint online, but since my pbi report is published on powerbi.com, when i want to click on"refresh data", i got an error message :

"You can't schedule refresh for this dataset because one or more sources currently don't support refresh."

my source is sharepoint online. (https://companyname.sharepoint.com/xxx/)

Please help me !

[v-haibl-msft]

@augustindelaf

Do you have another other data source except the excel files on SharePoint online?

Could you please give a screenshot of your Dataset settings in Power BI Service as below?

Best Regards,

Herbert

[augustindelaf]

Hi,

and many thanks for your help.

My data is only Excel files (xlsm) on sharepoint, and the query is an URL with parameters (like this : https://www.youtube.com/watch?v=6PZSZ53iSos&t=212s)

[augustindelaf]

Hi,

I was in contact with 2 Software Developers from Microsoft yesterday and thanks to Skype we saw what was wrong and now, it is fine.

The DataSet could not be updated because the Query was made with "Web.Contents>Excel.Workbook" and not "Sharepoint Files".

Then, I guess the Query Parameters could not be updated from PBI Service.

ie : 

It was : "Source = Excel.Workbook(Web.Contents("https://companyname.sharepoint.com/folder/Shared Documents/1-Regions/"&RegionsSettings&".xlsm"), "

it had to be:

"Source = SharePoint.Files("https://companyname.sharepoint.com/folder/", [ApiVersion = 15]),

Name_Sheet = xx"

Thank you anyway, the refresh now works perfectly, on schedule or on demand.

Many Thanks Anyway