Forum Discussion

Charlieb's avatar
Charlieb
Regular Visitor
3 years ago

Gateway -> Report

Hi   PowerBI and Data Gateways are very confusing. My IT team have setup a gateway, with a .csv file as source. I have my report (using pasted data) on the PowerBI web app. I've addded everything u...
Need Help
collinq's avatar
collinq
Icon for Super User rankSuper User
3 years ago

Hi Charlieb ,

 

I know that you mention that you have a .csv file "on the cloud".  But, the key is WHERE on the cloud is this?  Is it SharePoint Online, or OneDrive? 

When you go to "Get Data" you select the location (ShaarPoint Folder or Web for the OneDrive location or just text/csv or you could even use file for Onedrive) and then you go from there.

So, where exactly is the file is the key piece so that you can select your connection.

 

Charlieb's avatar
Charlieb
Regular Visitor
3 years ago

The data (a .csv) exists on a VM on a production network. The .csv is updated daily. The path is c:/xxx.csv or whatever. A Microsoft on-prem data gateway was installed, and it was setup with the filepath pointing to this location.

 

In PowerBI (Web) I can see this gateway, and it's online. Under 'Connections' I can also see this, I can see the path, and the authentication works (see photo). So everthing is a big green tick. Gateway working. Data connected. Now how do I get the data, into PowerBI? That's the bit that I cannot figure out!