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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
lmarangio
Helper I
Helper I

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.