Forum Discussion

l0l1313nn1's avatar
l0l1313nn1
Frequent Visitor
8 years ago
Solved

Power Bi Dataset and Gateway

I encountered an issue when trying to change dataset gateway.   I published a report using an odbc data source from power BI desktop.   On the service i tried changing the gateway for the dataset...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi l0l1313nn1,

     

    Please check whether you have added the data source to On-Premise Gateway.

     

    Besides, open your Power BI Desktop file and check how many data sources are  there under Data Source Settings. If your pbix file dataset contains multiple on-premise data sources, you should configure gateway for each of them.

     

    You said you typed a different credential to connect to data source when using the new gateway, right? Please enter the credential which is the same as that in your pbix file for a test.

     

    Best regards,

    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

As long as the new Gateway has all of the same sources set up, you should be able to freely choose it.  The shouldn't be any particular problems, besides going through the initial steps to ensure each data source is correctly added to the new gateway.

l0l1313nn1's avatar
l0l1313nn1
Frequent Visitor
8 years ago

the problem is i can't seem to choose the gateway for my published report. In Gateway Connection menu for the dataset, it says "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway."

 

Is it that since we used different ODBC ( i use one in the data source server, while my team member use ODBC from his pc), it is treated as different data source?