Forum Discussion

sss0379's avatar
sss0379
Frequent Visitor
8 years ago
Solved

Sharepoint Online - Data Set Refresh

Hi,   I created a visual reports in PowerBI Desktop by connecting to an Excel File in Sharepoint Online. Published it from Desktop to my online Workspace in App Service.   Now, my understanding w...
  • sss0379's avatar
    sss0379
    8 years ago

    Hi Anonymous

     

    Yes thats exactly my point if the Dataset is created in App Service then it has OneDrive Refresh Option at Settings

    If the Dataset is created in PowerBI Desktop and published then only Scheduled Refresh is available.

     

    Is this meant to be? Why is it so after all my DataSource is Onedrive/Sharepoint Online even then they are treated seperately.

     

    If PBIX is added to SharePoint ONline then only PBIX gets changed but my Sharepoint ONline excel file which is pointed in this PBIX  doesnt reflect the changes

     

    I dont think so there is a solution to this, this is the way it is designed. i had posted this question to check if my understanding is correct.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI sss0379,

 

Did any connection to other data sources in your excel file?
For normal xlsx files which stored in sharepoint online, power bi can use onedrive refresh handling it.

 

Regards,

Xiaoxin Sheng

sss0379's avatar
sss0379
Frequent Visitor
8 years ago

Hi Anonymous

 

No external connection in Excel files. 

 

Just simple 2 columns

 

Col1 || Col2

---------------

1.         1

2          2

3          3

 

Included this file in Sharepoint Online. Set a connection to this file in PBI Desktop. Create a table visualisation which displays this table. Published to PBI App Service. 

 

Now if I add a new row (4 4) in Sharepoint ONline in this Excel file, it does not get automatically refreshed even after 3 days and displayed in the Report/Dashboard in PBI App Service.

 

The only way it gets refreshed is Scheduled Refresh.

 

If I create a Dataset connection to Excel file on Shrepoint online in App Service it gets auto refreshed but not the one that is created in desktop and published on the app service.

 

Is scheduled refresh the only way to do for desktop files?

 

Thanks 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

    HI sss0379,

     

    Can you find onedrive refresh option at settings?
    If this option not appears in your dataset, it means you need to manually refresh or setting Scheduled refresh for this datasource.

     

    Spoiler

    This synchronizes your Power BI Desktop, or Excel, file between the Power BI service and OneDrive, or SharePoint Online. This does not pull data from the original data source. The dataset in Power BI will only be updated with what is in the file within OneDrive, or SharePoint Online.

    Data refresh in Power BI

    Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online

     

    Regards,
    Xiaoxin Sheng

    • sss0379's avatar
      sss0379
      Frequent Visitor
      8 years ago

      Hi Anonymous

       

      Yes thats exactly my point if the Dataset is created in App Service then it has OneDrive Refresh Option at Settings

      If the Dataset is created in PowerBI Desktop and published then only Scheduled Refresh is available.

       

      Is this meant to be? Why is it so after all my DataSource is Onedrive/Sharepoint Online even then they are treated seperately.

       

      If PBIX is added to SharePoint ONline then only PBIX gets changed but my Sharepoint ONline excel file which is pointed in this PBIX  doesnt reflect the changes

       

      I dont think so there is a solution to this, this is the way it is designed. i had posted this question to check if my understanding is correct.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI sss0379,

         

        Actually, Onedrive refresh not works for report which use sharepoint online folder/list connector.

        For this scenario, please use web/excel connector with file url to instead.

         

        Reference link:

        Use OneDrive for Business links in Power BI Desktop

         

        Regards,

        Xiaoxin Sheng