Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

External data in SharePoint Refresh Issue

Created excel file with 2 sheets of plain table data and 3 sheets with pivot table connecting to tabular model(external data connection). Developed Power Bi report off of this file and published in a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

How did you connect the excel file in Sharepoint site and created the report in Power BI Desktop? Whether you use web connector with excel file from sharepoint online or other method? If you created the report based on Excel workbook on SharePoint Online, Power BI performs OneDrive refresh. OneDrive refresh synchronizes the report with their source files. By default, Power BI checks about every hour if a dataset connected to a file on SharePoint Online requires synchronization. You can check the details in the part "OneDrive refresh" of this documentation.

 

Best Regards

Rena

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, I used the analysis service connection in Excel.