Dynamic data source for Power BI SERVICE

[YacinO]

For the use of my dashboards in Power BI Service, I need to vary my data source based on selection in a column. I've tried setting up a parameter to vary the data source based on the slicer selection of this variable, but I'm struggling with the M language solution. Also I don't even know if its possible for a client to select the variable and to refresh in live the dataset in Power BI Service. My data sources are xslx files.

Thank you in advance for your help!

[lbendlin · Accepted solution]

Dynamic M Query parameters only work with Direct Query data sources.  Your xlsx files are Import Mode only.

[lbendlin · Accepted solution]

Dynamic M Query parameters only work with Direct Query data sources.  Your xlsx files are Import Mode only.

[YacinO · Accepted solution]

Thanks, so its possible for the user in power BI Service to change the sources in live if its direct query data sources ! 🙂 

Thanks for your answer