Load data from Power Query to SQL Azure

[simontaylor]

Hi Experts,

I am trying to load power query dataset from Power BI to SQL Azure. Here is a document to follow:

Extract Power BI Objects with Azure Data Factory or Synapse Analytics (techtalkcorner.com)

But I can't do this part:

Is there a way to fix this? I want to use ADF to run it.

[simontaylor]

I have to go with Admin Consent to get this part done. It is done but I am facing 401 or 403 error from ADF. I think this is caused by permission issue from Power BI. It's not Service Tree related.

[simontaylor]

It is a tenant level change. Does anyone know how to make such changes?

[v-yingjl]

Hi @simontaylor ,

If you need to change the tenant settings for your organizations in Power BI Service, please contact your administrators who have the access to Tenant settings.

See: What is Power BI administration 

To access Tenant settings in Power BI Service, the role should be one of the below who can enable and disable Power BI features:

• Global Admin
• Power Platform admin
• Power BI admin

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[simontaylor]

Thank you. There is internal process to follow to make this happen.

[simontaylor]

It is a company wide setting. I can't make changes to enable service principal to call power bi to get dataset.