Cannot Connect Power BI Finance & Business Central

(6) Share

Report

Posted on by AXEON Man

1,075

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 (1)

All responses (5)

Answers (3)

Verified answer

AXEON Man 1,075 on at

Like (5)

Report

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

2 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Khushbu Rajvi. 20,647 Super User 2025 Season 2 on at

Like (4)

Report

If this helps: https://www.youtube.com/watch?v=WyVfR3yIvsM

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

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Dhiren Nagar 354 on at

Like (5)

Report

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.

Set up the Finance Power BI app - Business Central | Microsoft Learn

✅ Mark this as the verified answer if helpful.

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 4,141 on at

Like (3)

Report

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.

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data#checking-refresh-status-and-history

Please verify the answer if you feel it helpful

Regards

Pallavi Phade

Was this reply helpful? Yes No
AXEON Man 1,075 on at

Like (4)

Report

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.

Was this reply helpful? Yes No