News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Power BI Rest Api Data...

Microsoft Dynamics GP (Archived)

Power BI Rest Api Dataset in Power Bi Desktop

(1) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

I successfully managed to connect a java application to Power BI REST API and managed to create a dataset and added some data.

I can view this data from Power BI web interface, make reports, graph etc.

Is it possible to connect Power BI Desktop to this datasets and create custom reports from there? I'm asking this because the desktop application seems to be more complete. You can edit column names, merge tables, etc. all things that are not available in the web application.

Thank You

Hari

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Power BI Rest Api Dataset in Power Bi Desktop

Hi hari prasad,

It is possible to use REST API Dataset in Power Bi Desktop since April 2017 and it worked for me in the latest version of Power BI Desktop.

But even though you can create reports based on datasets from Power BI Service, you still cannot edit column names, merge tables, etc.

The features is called Power BI service Live connection.

To establish a connection to the published report, and create your own report based on the published dataset, select Get Data from the Home ribbon in Power BI Desktop, and select Power BI service. You can also select it from Get Data > Online Services > Power BI service.

After the report is finished, you can publish your report by selecting Publish from the Home ribbon in Power BI Desktop.

Thank you

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans