Forum Discussion

steventan's avatar
steventan
New Member
8 years ago
Solved

Switch Data Gateway to other Dataset

Hi. I want to switch or change data gateway from 'Out of Stock Report' dataset to 'Sales Movement Report'. But, failed.    What I tried before: - I clicked on "Discard" button and that Data Gatewa...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    steventan,

    Please check if the connection strings(servername, databasename, authentication type) of 'Sales Movement Report' dataset in Power BI Desktop are same as that you use to connect to MySQL database within gateway.

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    8 years ago

    steventan,

    Please post screenshot about the connection strings you use in Power BI Desktop and gateway.

    In Power BI Desktop, you can go to “File –> Options and Settings –> Data Source Settings” to check the connection string.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

steventan,

Please check if the connection strings(servername, databasename, authentication type) of 'Sales Movement Report' dataset in Power BI Desktop are same as that you use to connect to MySQL database within gateway.

Regards,
Lydia

steventan's avatar
steventan
New Member
8 years ago

Anonymous,

 

Yes, connection strings are same.

 

Regards,

Steven

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    steventan,

    Please post screenshot about the connection strings you use in Power BI Desktop and gateway.

    In Power BI Desktop, you can go to “File –> Options and Settings –> Data Source Settings” to check the connection string.

    Regards,
    Lydia