Forum Discussion

anshikak1's avatar
anshikak1
New Member
2 years ago

How to Enable Dynamic Ticker Filtering for API Data in Power BI?

Hi Power BI Community,   I'm working on a Power BI report that fetches data from several APIs provided by Financial Modeling Prep (e.g., Daily Stock Prices, Price Targets, Upgrades & Downgrades). I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi anshikak1 ,

 

Using Dynamic M Query Parameters it is possible to pass values from the slicer to M parameters. However, according to the documentation, these tables must be DirectQuery tables.

Dynamic M query parameters in Power BI Desktop - Prerequisites

 

From the description, it appears that these tables use Import mode, so dynamic M query parameters cannot be used. Please consider submitting this idea here to help PowerBI do better.

Welcome to Microsoft Fabric Ideas

 

Some related discussions:

can-i-build-a-power-bi-directquery-dataset-on-top-of-a-rest-api

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group