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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Ingo_BI
Frequent Visitor

Problem with connector Business Central // Power BI

Hi,

 

I have a problem connecting my PBI Desktop-file to Business Central.

 

I get this message when trying to Get data. I have a PBI Pro-license and I have a Basic-license in Business Central.

 

The really strange thing is when my collegue tries to Get data (with the exact same credentials as me) he manage to connect. But I cannot. How can that be? 

 

Skärmklipp.PNG

3 REPLIES 3
AmiraBedh
Super User
Super User

Based on this old thread , can you follow these steps :

 

 

1) added as a guest user on client tenant

2) guest user assigned BC license

3) allow external users to access Power BI content on Power BI admin portal - tenant settings

4) On power BI desktop sign in to an organisation (client tenant)

5) open the BC connector

6) signed into BC in to an organisation (client tenant)

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Is this really a viable solution for me? 

 

As stated in the starting post: my collegue who is using the exact same credentials as me can get data from BC. But I can't. 

 

There have to be a problem related to my computer or something. I have cleared the cache in PBI desktop btw. 

I don't know how your laptop or the one of your colleague is configured.

Please try to connect Dynamics 365 Business Central with the built-in connector by Power BI Desktop.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Kudoed Authors