Forum Discussion

csaethre19's avatar
csaethre19
Helper II
3 years ago

Dynamically change Database Endpoint

I am making reports that need to be updated live so I am using Direct Query mode via SQL statements to create these.    We have two versions of our database, there is one for research and one for p...
Need Help
  • csaethre19's avatar
    csaethre19
    Helper II
    3 years ago

    Thank you for the suggestion and resource. I went through this step by step and managed to set up a bound parameter for the database URL endpoint and database name to change in the M query dynamically. However, it was not successful as it breaks my visuals and says that it is unable to read beyond the end of the stream. I am using Direct Query mode and I am guessing that this kind of thing is not supported while using Direct Query. 

     

    If you have any suggestions for dynamically changing the database while using Direct Query mode that would be appreciated. 

     

    Thank you!