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

When you are in your PBIX file using Power BI Desktop, you have an option called "Data Source Settings" (little arrow menu under 'Edit Queries').  You need to make sure each data source here is identical to what is in the gateway.

 

The simpliest example of where this can trip some people up.  If they are using an excel file which is locally found under "C:\Folder\File.xlsx" but the gateway has "\\Computer\Folder\File.xlsx".  These are considered different sources and the gateway will not accept the project.

 

So the question will have to fall back to you with your troubleshooting.  Is the source on your gateway identical to what is in the project you are trying to link?

amarkbass's avatar
amarkbass
Frequent Visitor
8 years ago

Thank you so much Anonymous!

 

I've been literally pulling my hair out over this!

 

Our gateway is functioning perfectly but would not accept a dataset because there were additional 'unsanctioned' data sources added in subsequent geneartions to our model.