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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Yanbo
Frequent Visitor

Querying specific column data with Power BI API

Hi,

My manager isn't pleased with the visual design for the filters and wants to use external ones that connets to the embed using the API. I am currently working in Angular and I've figured out how to filter by specific values on the embed using the Power BI API's. The problem is that this is not dynamic. For example, currency types, there are a ton of currency types: USD, CAD, etc. However, the user may only have a few in their table, that that's where I'm stuck right now. I don't want to hard code every type of currency into the filter for obvious reasons and the only solution I can think of right now is to have the column data so I can run some function to return me the unique values and display that to the external filter. Is there any way I can query a data base for a specific column and its data? Preferrably using a http request library in Javascript or in Postman.

Thanks

1 REPLY 1
Anonymous
Not applicable

Hey @Yanbo, this is the full documentation of PBI REST API: Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn, where you can find all the requests you might need.

 

Going back to your question: sadly no. Datasets in PowerBI are not Databases, and that's why you do not have many of the possibilities that you would expect from a database, such as querying for values in a specific column. But again, all you can do with PowerBI REST API is described in the documentation linked above. If you do not find the request you want, then it doesn't exist. 

 

Hope I helped you!:)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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