Forum Discussion

cmncp's avatar
cmncp
Icon for Helper III rankHelper III
9 years ago
Solved

Combining tables causing refresh to fail in Power BI Service

Background I have some excel files hosted in on-premise sharepoint folder.  There is one file for each country, and the contents of each file are the same.  I want to combine the contents into a sin...
Need Help
  • cmncp's avatar
    cmncp
    9 years ago

    GilbertQ  Just wanted to let you know I was not able to get it working using the Folder option.  I was unable to resolve the access errors.  However, I was able to get it to work using the Sharepoint Folder option. They key there is to initially select the SharePoint Site, and then apply to filter to select the individual folder that has my files.

     

    Thanks again for your suggesitons.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi cmncp


Why don't you rather get the files from a Folder? In SharePoint you can also get to Document Libriaries via a UNC or Folder location.

 

Then once you have done that, when you are configuring your Gateway, you can point it to the same folder location? As well as ensure that the Service Account that the Gateway Service runs under, also has read permissions to your SharePoint Document libriary.

 

I have done this successfully in the past and it works really well.

cmncp's avatar
cmncp
Icon for Helper III rankHelper III
9 years ago

Hi GilbertQ.

 

Thanks for the reply.  Were you using SharePoint online or on-premise.  In my experience, getting files from a folder did not work with on-premise SharePoint.

    • cmncp's avatar
      cmncp
      Icon for Helper III rankHelper III
      9 years ago

      GilbertQ  Very good blog post.

       

      I am having issues trying to set up the gateway.  It is telling me the credentials are invalid.  I am not the owner of the SharePoint site, but I do have access.  In fact I created the folder and copied the files into it.

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        9 years ago

        Hi cmncp

         

        Thanks for the comments on the blog post.

         

        I would suggest looking to see what LogOn Account the Power BI Gateway Service is using on the Server.

         

        Once you got the domain account, then add this same domain account into your SharePoint Document Libriary Permissions. If this Domain Account is not in there it will then fail when trying to Add it as a Data Source in the On-Premise Gateway.

         

        Also when you installed the On-Premise Gateway did you install it in Personal Mode or Enterprise mode?