Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

User selected value as Parameters to Web API

I have a requirement where the user can select a value from a slicer in Power BI report and it needs to be passed as query parameter string to a web API call from Power Query.   Right now , I can m...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Only possible in Direct Query mode. Confirm your storage mode.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lbendlin ,

Thanks for your reply.

Currently storage mode is import.

 

The below link seems to suggest that  DirectQuery is not supported when data source is web

Power BI data sources - Power BI | Microsoft Docs

Or  it is possible to change storage mode to DirectQuery when the data sourse is Web API?

 

If so, how can I change storage mode to DirectQuery?

 

Many thanks

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    No, i think you have hit a dead end with this requirement. Cannot be done in Power BI.