Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
simontaylor
Microsoft Employee
Microsoft Employee

Load data from Power Query to SQL Azure

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:

simontaylor_0-1651773090519.png

 

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

5 REPLIES 5
simontaylor
Microsoft Employee
Microsoft Employee

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
Microsoft Employee
Microsoft Employee

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

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.

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

simontaylor
Microsoft Employee
Microsoft Employee

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.