Cannot Connect Power BI to Business Central

(0) Share

Report

Posted on by john.ellis

3,530

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)

All responses (4)

Answers (1)

Sort by

Verified answer

Francisco Bedolla 1,123 on at

Like (1)

Report
Copy link

Link copied!

File - Setup and options - data setup

Edit Permission - start as another user

or delete permissions

and start a new connection again

Was this reply helpful? Yes No
Shivi1307 13 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
john.ellis 3,530 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,696 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No