Forum Discussion

NovaBI's avatar
NovaBI
Icon for Post Patron rankPost Patron
5 years ago
Solved

Connection to MYSQL, personal gateway

Hi,   I was publishing a report that is using a connection to MySQL as well as a dynamic source (which I know does not work with PBI Service, but i used relative path and that worked in PBI Desktop...
Need Help
  • NovaBI's avatar
    NovaBI
    Icon for Post Patron rankPost Patron
    5 years ago

    Hi GilbertQ ,

     

    thanks for the hint, that worked.

     

    Last question, is there a way to change the source for all tables in one go?

     

    Otherwise I have to do it via advanced editor one by one, but I don't see anything reasonable in Data Source Settings.

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      5 years ago

      Hi NovaBI 

       

      You would have to change it in the advanced editor

       

      You could do this using Tabular Editor which could be quicker.