Forum Discussion
User-Interactive OData Requests in Power BI Desktop
HI JanSir,
You can take a look at the following document to create a parameter to affect the backend query tables and bind with table fields to use on data view side with filters.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Thank you for this suggestion, but it does not provide a solution. In the prerequisites is written: "To work through these procedures, you must have a valid M query that uses one or more DirectQuery tables.". OData is not a DirectQuery source.
Hi JanSir,
Perhaps you can refer to the following link about create custom connector to expand and add directquery mode support to it if helps:
Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn
Regards,Xiaoxin Sheng
Hi Anonymous
Yes, the ODBC connector shall be a possible solution. However, it is not convenient in our case to implement the ODBC connector to our dataset.
We conclude that there is no straightforward way of resolving this issue with our current setup.
Thanks,
Jan