Unable to connect Finance App for Business Central to my data

[Sofie-Olesen]

Hi all, 

I am trying to connect the Microsoft prebuilt Finance App for Business Central to our company's data. I have tried numerous times already and every time it fails.

I'm on a Danish platform of BC365 and updated to version 26.2. The folowing is the error I receive:

Behandlingsfejl: [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.
Klynge-URI: WABI-WEST-EUROPE-F-PRIMARY-redirect.analysis.windows.net
Aktivitets-id: 240c3fbd-6679-7a42-b841-f82942d37c89
Anmodnings-id: d6e7a363-145a-3165-6649-9c0124e5eb71
Klokkeslæt: 2025-06-30 07:53:33Z

Thank you in advance!

[v-pgoloju]

Hi @Sofie-Olesen,

Just following up to see if the solutions provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @Sofie-Olesen,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @Sofie-Olesen,

Just following up to see if the troubleshpoot points provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju · Accepted solution]

Hi @Sofie-Olesen,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Could you please check below points.

Check Permissions: Make sure you have Build access to the dataset; ask your admin to confirm.

Reauthenticate: Sign out and back in to Power BI Desktop, clear cached credentials if needed.

Verify Dataset Type: Exporting to .pbix may not be allowed for live connection or DirectQuery datasets.

Use Power BI Service: Try exporting from the Power BI web portal instead of Desktop.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @Sofie-Olesen,

Thank you for reaching out to the Microsoft Fabric Forum Community. And also thanks to @Akash_Varuna for prompt and helpful response.

To fix this, go to Transform Data in Power BI Desktop and check the “G/L Entries” query. If it's mixing data from other queries while also pulling from the source, that’s the issue. Instead, load each source into its own separate query first, then do any merges using those this avoids the error.

Best regards,
Prasanna Kumar

[Sofie-Olesen]

Hi Prasanna,

Thank you for your answer.

I cannot open the Power BI in Power BI Desktop as i canoot export to the right format.

Kind regards

Sofie Olesen

[Sofie-Olesen]

Hi Akash,

Thank you for your answer. I succeded in changing the privazy level to organizational. Now the Dashboard is connected, but I see only part of the visulizations. 

I have tried changning the privacy settings without succes. I simply cannot find the place to change these. Can you guide me even further?

[Akash_Varuna]

Hi @Sofie-Olesen It might be due to combining data sources with different privacy levels in Power BI. Start by ensuring that all data sources in your report have the same privacy level (e.g., "Organizational"). Go to File > Options and settings > Data source settings, and adjust the privacy settings. Additionally, try enabling "Ignore Privacy Levels" in the Privacy settings under File > Options > Privacy to allow data combination.