Forum Discussion

trt18-sistemas's avatar
trt18-sistemas
Icon for Advocate IV rankAdvocate IV
3 years ago

Dataset Refresh API doesn't work from Power Query

Hi there, I'm trying to implement a Power Query Script that refresh a dataset by using "Dataset - Refresh Dataset in Group" REST API (https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/ref...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi trt18-sistemas ,

 

It seems that the issue is with the content_type parameter in the header. The content_type parameter should be set to "application/json" instead of "application/x-www-form-urlencoded". Try changing the content_type parameter to "application/json" and see if that resolves the issue.

Try the modified code:

let
    auto_token = "Bearer " & GetAccessToken,
    url_datasetlist = "https://api.powerbi.com/v1.0/myorg/groups/workspace_id00000/datasets/dataset_id00000/refreshes",
    content_type = "application/json",
    body = "{""notifyOption"": ""MailOnCompletion""}",
    Source = Json.Document(Web.Contents(url_datasetlist, [Headers=[Authorization=auto_token, #"Content-Type"=content_type], Content=Text.ToBinary(body)]))
in 
    Source

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

trt18-sistemas's avatar
trt18-sistemas
Icon for Advocate IV rankAdvocate IV
3 years ago

Hi Anonymous ,

Thanks for your reply. I forget to mention that I've tried using Json and it returned a error. I've pasted your code on Power BI and the same error pop up again (message below). In this case, seems that the problem is how message is formated, but I can't see any thing wrong on the content.

 

Just in case, here is the print screen from my M code: