Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Corey-Flinders
Frequent Visitor

Is it Possible to Access the Power BI API using Power BI

Hi,

 

Is it possible to access the Power BI API using Power BI itself? For example could I use Power BI to use the API to Get the Refresh History for a dataset using the Get Refresh History In Group API call?

 

The reason I ask is that I have a requirement to show the last update time on some of my reports. Currently I am using the technique to access the TimeZoneDB service as outlined on this RADCAD Blog page.

 

This works fine, but it does introduce a dependency on a third party system which I'd prefer to avoid.

 

The use of the Get Refresh History In Group API call looks very attractive. As it gives additional information which I can highlight in the report should the refresh have failed for example.

 

Any thoughts will be most welcome.

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Corey-Flinders ,

 

Please refer to this video about how to access json api in power query.

 

Regards,

Jimmy Tao

Hi @v-yuta-msft,

 

Thanks for the link. The video is interesting. Unfortunately it isn't exactly what I was looking for.

 

I'm more interested in the specifics of using the Power BI API with the Power BI application and Power BI service.

 

For example:

  1. Do I need to register an application.
    Which seems a little redundant given I'm using Power BI to access a Power BI API.
  2. How do I authenticate to the API?
    Especially given as I can't prompt for credentials for an OAuth token

Do you, or anyone else on the community, have any information specific to using the Power Query capabilities in Power BI to access the Power BI APIs?

 

With thanks.

 

-Corey

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.