Forum Discussion

YacinO's avatar
YacinO
Regular Visitor
2 years ago
Solved

Dynamic data source for Power BI SERVICE

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!

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

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

  • YacinO's avatar
    YacinO
    2 years ago

    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

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

    • YacinO's avatar
      YacinO
      Regular Visitor
      2 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi YacinO, I know this is a late reply but, were you able to get it to work (reference dynamic sources in PBI service)?