Forum Discussion
Direct Query to Azure Databricks Hive Tables not folding
I am trying to use direct query on a Very large table (tens of billions of rows) that pulls data from hive tables on Azure Databricks which points to ADLS Gen2(delta files). The issue is that for w...
Anonymous , have you checked Dynamic M parameters
https://blog.crossjoin.co.uk/category/dynamic-m-parameters/
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
Hi amitchandak, Yes I have tried Dynamic M queries and it is all fine if I had the parameters inside my Powerbi Desktop, but the parameters are in a seperate Paginated report. How would I get the value from those parameters from a seperated paginated report dynamically into my dataset is the problem I had with that approach.