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 Finance & Business Central

(4) ShareShare
ReportReport
Posted on by AXEON Man 836
I have a Power BI Premium License and a production Business Central environment I'd like to connect to.

I've connected the Business Central Inventory App but the Finance App will only show demo data.

Here are my apps in Power BI:


 
I can connect to the data in Power BI for Desktop:

 
I believe I'm entering this correctly:

It authenticates, then say this for a while:

 
Then this:


Any ideas?
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • AXEON Man Profile Picture
    AXEON Man 836 on at
    Cannot Connect Power BI Finance & Business Central
    It's funny, you all pointed to the guide I posted that I was going through.  I feel a little silly as I should have worked it out before posting but maybe this will help someone else.
     
    The email I got when the nightly refresh happened had more data and that helped:
     

    An error occurred while processing the data in the semantic model.

    Refresh failed:

    Finance app has failed to refresh.
    Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
    <ccon>[Unable to combine data] Section1/G\/L Entries/Combine Queries references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.</ccon>. The exception was raised by the IDbCommand interface. Table: G/L Entries.
    Next refresh for Finance app is scheduled for September 7, 2025 7:00 UTC.

    The guide specifically mentioned this error and offers a fix and it worked:

     
    The answer was to change the privacy setting to "Organization" and voila, I have data!  WOOHOO!

    Thanks again, everyone.
  • Suggested answer
    Pallavi Phade Profile Picture
    Pallavi Phade 292 on at
    Cannot Connect Power BI Finance & Business Central
    Namaste ,
     
    I haven’t personally used the Power BI built-in app, but I have gone through some articles on it. The link below might be useful, as it highlights the data refresh issue.
     
     
    Please verify the answer if you feel it helpful
     
    Regards 
    Pallavi Phade
  • Verified answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 317 on at
    Cannot Connect Power BI Finance & Business Central
    Hi,
     
    You need to complete the setups in the Power BI Finance App in order for the data to sync correctly, it will keep on giving error until those setups are completed.
    This setup is given in Power BI Connector Setup in the Finance Report section.
     
     
    ✅ Mark this as the verified answer if helpful.
     
  • Verified answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 19,052 Super User 2025 Season 2 on at
    Cannot Connect Power BI Finance & Business Central
  • Verified answer
    AXEON Man Profile Picture
    AXEON Man 836 on at
    Cannot Connect Power BI Finance & Business Central
    I'm going through the pre-requisites here, perhaps this will help.

    https://learn.microsoft.com/en-us/dynamics365/business-central/finance-powerbi-app-setup

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

Dynamics 365 Community Calls Return
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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
Sumit Singh Profile Picture

Sumit Singh 2,710

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,675 Super User 2025 Season 2

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,203

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans