Forum Discussion

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
8 years ago
Solved

Gateway Source Issue

I am well versed in the data gateway and am the admin of a gateway with a plethora of source connections . . . all of which work. This is not my first Rodeo. I am, however, failing to connect to a fo...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Your folder paths match, so my next troubleshooting step would be to check the "Data Source Settings" button in Power BI Desktop.  This should give you the concise listing of all of the data sources in your Power BI file.  Chances are there is one in there that isn't properally configured in your gateway.

gabrielvigo's avatar
gabrielvigo
Icon for Helper I rankHelper I
8 years ago

Something similar happens to me. I have a data set with two sources. One source is a SQL database and the other is an XLSX file in a folder on the shared disk.

If I leave only the SQL data source, there are no issues. The problem is when I want to connect to the data source on the shared disk.
I have the same issues that you have.

 

It would be nice if someone who has had experience with files on shared discs, on premise, help us with this.

I have been advised to use SharePoint Online to host the files. I'm going to do tests, if it works, I'll tell you kcantor.

But the ideal would be to solve the shared disk.


Regards!

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
8 years ago

gabrielvigo

I have other datasets pulling from the same shared drive and they work. I refuse to use sharepoint as I have lost connection with my refresh when using it. Microsoft had to go in and reset the backside to point it back to our server to keep me from losing a massive model. After that I vowed to never connect through sharepoint again.