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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

Had the same problem. All sources worked well (SSAS+SQL+Excel from Sharepoint folder) until I combined. The solution was to enable the "Allow user's cloud data sources to refresh through this gateway cluster" on the gateway.