Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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:
We don't understand how can we access this file to make reports. Can someone help please?
Thank you very much
Solved! Go to Solution.
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.
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
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.