web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Cannot Connect Power B...
Small and medium business | Business Central, N...
Answered

Cannot Connect Power BI to Business Central

(0) ShareShare
ReportReport
Posted on by john.ellis 3,500

Hi:

I have done this, before.  So, I don't know why I'm having an issue with this all of a sudden.

In Power BI Desktop, I'm logged in with Business Central administrative credentials.

But, when I choose Get Data...Online Services...Microsoft Dynamics 365 Business Central, I'm not connected to the correct environment.  I'm connected to a different company's environment.

Perhaps, is this happening because I only have a free license to the environment that I want to access?  I didn't think that I would need a Pro license just to access the data from Business Central in Power BI Desktop.

Otherwise, what am I doing wrong?

Thanks!

John

I have the same question (0)
  • Verified answer
    Francisco Bedolla Profile Picture
    Francisco Bedolla 1,119 on at
    RE: Cannot Connect Power BI to Business Central

    File - Setup and options - data setup

    pastedimage1657927871490v1.png

    Edit Permission - start as another user

    pastedimage1657927935250v2.png

    or delete permissions

    pastedimage1657927966850v3.png

    and start a new connection again

  • Shivi1307 Profile Picture
    Shivi1307 13 on at
    RE: Cannot Connect Power BI to Business Central

    Hey John,

    When we connect Power BI to Business Central SAAS (not on prem ) , it asks us to login to BC if not already logged in.

    So what you can do, log out of BC, connect PBI to BC via Get data-> online services and then PBI will ask you to login to BC. Provide your credentials, amd then check if correct company is coming or not.

  • john.ellis Profile Picture
    john.ellis 3,500 on at
    RE: Cannot Connect Power BI to Business Central

    Thank you, Francisco!  This is exactly what I needed!

    Before, even logging in the "old fashioned way" and using the credentials of the organizational environment did not work.

    Your way worked!  Thanks, again!

    John

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,668 Moderator on at
    RE: Cannot Connect Power BI to Business Central

    How Do I: Publish a Power BI report to another BC tenant? – think about IT

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,160

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,943

#3
Sumit Singh Profile Picture

Sumit Singh 2,823

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans