Power Query in Excel

(0) Share

Report

Posted on by john.ellis

3,518

Hi:

I'd like to use Power Query in Excel to find Business Central tables just like we can in Power BI.

But, I don't see a list of tables -- only fields for Web Service URLs.

Can you use Power Query in Excel to find tables?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Inge M. Bruvik 1,165 Moderator on at

Like (1)

Report
Copy link

Link copied!

If you are running Business Central online you can not access the database tables directly only the API's and webservice.

If you are running BC On -prem you can connect to the SQL server from Excel.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,084 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, yes, as far as I know, the BC connector in Power BI is not included in Excel and can only be connected using Odata feed.

Of course, you can also synchronize data to Azure service or Dataverse, and then read data from there which is a bit troublesome.

Or you can try the following interesting feature.

Set Business Central data to show in Excel Organization Data Types Gallery (Featured tables in Power BI)

https://yzhums.com/25234/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
pman on at

Like (0)

Report
Copy link

Link copied!

Hello

Over the past few years, I have created various Excel reports for customers that use PowerQuery and ODATA to extract data from Business Central and evaluate it with PowerPivot. This works perfectly for the customer. Until now, I have been able to access my customers' ODATA with my partner account in order to design or customize the reports for them. Since around mid-2025, however, this has no longer been working. I can log in and authenticate in PowerQuery via the organization account and login as another user with my partner account, but as soon as I try to update the data, I get a message saying that I have to log in. Which is what I just did. With my partner account, I can easily access the customer's Business Central Cloud (SUPER permission) and log in to PowerQuery, but when I try to retrieve the data, I am constantly prompted to log in.

Does anyone have any tips on how I can make ODATA queries from Excel or PowerBI Desktop with my partner account?

(No, I don't have my own app that I could register. I want to use Excel and PowerBI)

Regards

Daniel

Was this reply helpful? Yes No