Forum Discussion

Elvinas's avatar
Elvinas
New Member
1 year ago

How to switch Azure tenant/directory for Azure Resource Graph data connector?

Hello,   I am trying to evaluate FinOps hub toolkit and have issues connecting PowerBI reports to the FinOps hub and getting reasonable reports from it. When trying to open Governance report, I hav...
Need Help
Tutorial Requests
grazitti_sapna's avatar
grazitti_sapna
Super User
1 year ago

Hi Elvinas,

It seems that Power BI is swtiching tanent and logging with another tanent credentials, you can double check the and correct the same by following below steps:-

 

If you're using Power BI Desktop, try these steps to force authentication into the correct tenant:

  1. Open Power BI Desktop.
  2. Go to "File" > "Options and settings" > "Data source settings".
  3. Look for Azure Resource Graph and select it.
  4. Click "Edit permissions" and then "Clear permissions".
  5. Reauthenticate using the correct tenant account when prompted.
  6. Try reconnecting to the FinOps Hub data source.

If you're using Power BI Service (Online), follow these steps:

  1. Open your dataset in Power BI Service.
  2. Go to "Settings" > "Datasets" > Select your dataset.
  3. Under Data source credentials, click "Edit credentials".
  4. Choose OAuth and select the correct tenant account.

Set Tenant ID in Azure Resource Graph Queries (Advanced Option)

You can explicitly specify the tenant ID in your Resource Graph queries by modifying the connection string. In Power BI’s Advanced Editor, check if there’s an option to provide the correct tenant ID manually.

 

Switch Tenant in Azure Portal and Restart Power BI

 

  • Go to Azure Portal.
  • Click your user profile (top right).
  • Switch to the correct tenant.
  • Close and restart Power BI and try reconnecting.

Since you mentioned that tenant switching is greyed out, your organization might have enforced tenant restrictions via Azure AD policies. You may need to check with your Azure AD administrator to see if they have restricted Power BI from switching tenants.

 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!