cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Data Source on Gateway not showing on Power BI Datasets

Hello Everyone,

 

We have installed Power BI Gateway on a separate machine that is on our network (but not Power BI Desktop). We have configured it, and added a Data Source which is a .TXT file (just for test purposes) that is connecting successfully, as you can see on the image:

datasource_gatewayPBI1.PNG

 

 

We are on the list of Users of that DataSource and Admins of that Gateway. However, we cannot find the Data Source anywhere to use it on a report. Even on Power BI Desktop (on our personal PCs), it is not listed on the Power BI Datasets:

datasource_gatewayPBI2.PNG

 

We don't understand how can we access this file to make reports. Can someone help please?

 

Thank you very much

 

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I've noticed your text file is listed as "C:\", which indicates its on the local harddrive of the gateway.  Projects on the web will have no valid path that references a local harddrive.  As such you'll need to move the file to a network folder and ensure that the file path is in the format of "\\<servername>\<folder>\<subfolder>\<etc...>\<file>"

 

The next question i'd have for you.  The Power BI Service dialogue box, was that a dialogue box from your Power BI desktop?  If so that particular selection "Power BI Service" looks like when you want to connect directly to an existing data model.

 

 

Instead you want to use 'Get Data' -> 'Text/CSV' and then choose the file using the identical format from the gateway.

View solution in original post

2 REPLIES 2
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

 

It seems that you have add the csv data source to data gateway successfully.

 

By my tests, if you only add the data source to gateway but you have not published the report with that csv data source to Power BI Service, you will not see the data source under the Datasets lists in Power BI Service. So when you get data with Power BI Datasets in Power BI Desktop, you won't find it.

 

In addition, if you want to create report in Power BI Desktop with that csv file, you should click Get Data>> File>> CSV.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

I've noticed your text file is listed as "C:\", which indicates its on the local harddrive of the gateway.  Projects on the web will have no valid path that references a local harddrive.  As such you'll need to move the file to a network folder and ensure that the file path is in the format of "\\<servername>\<folder>\<subfolder>\<etc...>\<file>"

 

The next question i'd have for you.  The Power BI Service dialogue box, was that a dialogue box from your Power BI desktop?  If so that particular selection "Power BI Service" looks like when you want to connect directly to an existing data model.

 

 

Instead you want to use 'Get Data' -> 'Text/CSV' and then choose the file using the identical format from the gateway.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!