Forum Discussion
Switch Data Gateway to other Dataset
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,
Lydiasteventan,
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
What data sources are contained in the 'Sales Movement Report' dataset? To schedule refresh for the 'Sales Movement Report' dataset, you would need to add all the data sources of the dataset within gateway. Once you add all the data sources, you will be able to choose “Use a data gateway” option for the 'Sales Movement Report' dataset.
Regards,
Lydia
Hi Anonymous,
Both data sources are the same: MySQL database. But, now, I wish to remove 'Out of Stock Report' dataset and change/switch its data gateway to 'Sales Movement Report'.
Before this, I tried to remove 'Out of Stock Report' dataset. After removed, in 'Sales Movement Report' dataset 'Use a data gateway' option menu, I failed to choose back the data gateway that 'Out of Stock Report' dataset used before.
Do you why can't use back old data gateway? Thanks.
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,
LydiaAnonymous,
Yes, connection strings are same.
Regards,
Steven
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