Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rest API to pull data into Power BI

Hi Experts.. using direct query.. I am not sure what I am doing wrong. Here is the scenario. I have a Rest API URL one with parameters and one without parameters. The Rest API without parameters i...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Anonymous 

The Rest API without parameters if I copy and past that URL in google should or Power BI using a C dataConnector show me all the data in the dataset since I have no parameters?

->Reply:

Without meeting the API limitations, it should show all data.


If I have parameters then in the Rest API then only show me the data based on the parameters?

->Reply:

With Parameter wrote in the query, it should show data based on the parameter.

References:

https://community.powerbi.com/t5/Power-Query/Rest-API-With-User-Selected-Parameters-As-Data-Source/m-p/805935

https://community.powerbi.com/t5/Power-Query/API-with-Parameters-in-PBI/td-p/654051


The Rest API the one with out the parameters I have defined the parameters in Power BI via query parameters, and this should technically pull only that data? Based on my parameters selection?

->Reply:

I don't understand this problem, it seems the same one as the second one.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.