Forum Discussion
Cloud-based gateway
How would you connect a gateway to a cloud-based location like sharepoint. I am trying to refresh a pdf file from sharepoint and getting the error that I need a gatway.
Any solutions? please include screenshots if possible!
Hi rachelmatzel ,
The responses by Hariharan_R are correct and the link that was sent is the correct link. PDF connector does not work in Premium capacity unless a gateway is created.
While you are connecting to a SharePoint List Online (which does not need a gateway) you are getting a PDF file from that List. To read that PDF, you have to have the connector set in a gateway.
In this case, the point is not WHERE you getting it from, it is WHAT you are getting.
If you want to see the data from a PDF file, and you are in Premium, you have to set up a connector. Whether that file is sitting in OneDrive, SharePoint or otherwise, you will need to get the gateway setup.
Let us know if that resolves this for you!
7 Replies
- Hariharan_RSolution Sage
Hi,
You dont need if you are refering O365 sharepoint online as it is a cloud. You can refresh your dataset. Share your error message for more clarity.
Refer the below link for reference,
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
Thanks
Hari
- rachelmatzelFrequent Visitor
Hi Hari,
I am trying to refresh the dataset that has a pdf located within sharepoint. This is the error message I am getting when trying to do the refresh.
However, when I go to the settings of the dataset it tells me I don't need a gateway because all of the data is cloud-based. Not sure what to do here.
- Hariharan_RSolution Sage
Hi
The error message is clear. You are using PDF connector which is from Sharepoint. Eventhough it is from Sharepoint you need to use data gateway to connect PDF files which is also mentioned in Microsoft Doc - https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-pdf
Configure a data gateway if not already or reach to your Power BI Admin team and ask them to configure the PDF data source in gateway and get access to that data source. You need to map it with that data gateway then your refresh will work.
Thanks
Hari