Forum Discussion

rachelmatzel's avatar
rachelmatzel
Frequent Visitor
4 years ago
Solved

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!

  • collinq's avatar
    collinq
    4 years ago

    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

    • rachelmatzel's avatar
      rachelmatzel
      Frequent 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_R's avatar
        Hariharan_R
        Solution 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