Forum Discussion

stevencheung_bm's avatar
stevencheung_bm
Frequent Visitor
1 year ago
Solved

Power BI Pro unable to refresh data from the excel source file

Having a serious problem, under the Power BI Pro license, my online report uable to get refresh to the data semantic model which linking to the excel source file saved in my onedrive. It impact a lot...
Dataflow
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi stevencheung_bm 

    Welcome to the Microsoft Fabric Forum,

     

    As correctly noted by andrewsommer , while your Excel file is in OneDrive (accessible via a SharePoint URL), Power BI is interpreting the data source as a Web connection through the Web.Contents() function in Power Query. This method requires an on-premises data gateway when the report is published to the Power BI Service.

    To avoid needing a gateway, Power BI must establish a cloud-native connection. This can be done using either the SharePoint connector (SharePoint.Contents()) or the native OneDrive for Business integration, both of which authenticate directly to the cloud and do not require a gateway.

    It's likely that the data refresh initially worked because Power BI Desktop can handle local and web connections without needing a gateway. However, once deployed to the Power BI Service, refreshes fail unless the data source is accessible via a supported cloud connector.


    If this information helps resolve your issue, kindly consider marking this response as the Accepted Solution, as it may assist other community members facing similar challenges.

     

    Thank you for being part of the Microsoft Fabric Community.

  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi stevencheung_bm 

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

    Thank you.

stevencheung_bm's avatar
stevencheung_bm
Frequent Visitor
1 year ago

thank you so much Andrew for the reply. 
I found the cloud connection of the semantic model datasource path is somthing like: 
Web{"url":"https://xxxxxxx.my.sharepoint.com/personal/xxxxxxxxxxx/Documents/PowerBI/DataSource/xxxxxx.xlsx"}

This is the original path that when I create the report. I just simply choose this data as file source while I create a new report, then it auto become a data semantic model in Power BI.  In the first few day when I developing the report, any update of data in source file can be sync/refresh when I press "refresh",  just recently when I go to the original file, insert some data row, then it becomes unable to refresh.    Not sure is that someting wrong that I made.