Dataset can not be refreshed in workspace

[kemppaik]

I'm trying to generate some reports to pull from a REST API.  I can get the queries to work from a desktop and refresh the data on demand with no issues.  However, when the report gets published to the workspace, the dataset can not be refreshed.

This is one of the data queries:

This works when on the desktop.  When it gets uploaded into the Workspace we are getting this error.

How can I get around this?

[PhilipTreacy · Accepted solution]

Hi @kemppaik 

In PBI Service the URL you are querying must be static, so you need to split the URL into the root domain, and supply everything else in the Relative_Path parameter, e.g.

api_url = "https://us.api.knowbe4.com/",
RelPath = "v1/phishing/security_tests/" & PSTID & "/recipients?per_page=500",

data= Json.Document(Web.Contents(api_url,
   [ 
     RelativePath = RelPath,
     Headers = ...............
   ]
   )
   )

Refer to Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An... 

Regards

Phil

[kemppaik]

Hi @PhilipTreacy ,

This has helped me get further.  Any ideas why I'm getting messages about why my applied steps are causing this error when refreshing the dataset in the workspace?  I don't get an error on my desktop.

This is my KB4TrainingCampaignsUserSettings Query:

This is the KB4Training CamaignUsers function that I was originally having issues with - but now seems to be resolved:

Thanks.

[v-deddai1-msft]

Hi @kemppaik ,

The error message means within the same query, you’re trying to access multiple data sources and they’ve been set up with incompatible privacy levels.

You need to head over to the Data Source Settings window and set up your ALL your data sources in that query to the same privacy level; either ALL Public or ALL Organizational.

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

Best Regards,

Dedmon Dai

[kemppaik]

I only have one data source,  I've tried every privacy setting and still get the same error.

[v-deddai1-msft]

Hi @kemppaik ,

Would you please try to edit the privacy level in data source settings in power bi service? the operation on desktop will not effect the settings in power bi service.

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

Best Regards,

Dedmon Dai

[kemppaik]

It is already the same as what is in my desktop: