locked
Power BI: How to set refresh for an excel file uploaded in PowerBi.com? RRS feed

  • Question

  • Hi All,

    I have opened an account in powerbi.com and taken the 60 days trial for power bi pro. I've developed power pivot and generated power views in share point 2013. But, I'm new to Power BI desktop. I have created a report in power BI desktop and published to powerbi.com. Also, I have uploaded an excel file directly to powerbi.com and created the report from the workspace available there itself and pinned the report to dashboard also. Everything is fine till this. But, I need to refresh the file which I have uploaded. I have some dummy data in excel sheet.

    ZipCode State ZipName
    2345 AA AA
    456 BB BB
    6787 CC CC

     This has been created as a table and then added to data model. So, power pivot has been created for the same. Then I have uploaded this file to powerbi.com site. But, I'm getting an error message while trying to schedule refresh for the same.

    "You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model."

    How can I create a data model connection? How can I schedule refresh for an excel file like this?

    Regards,

    Julie


    Wednesday, September 9, 2015 11:55 AM

Answers

  • Hi Liao,

    I am able to refresh the dataset after installing power BI gateway from Microsoft site.

    Regards,

    Julie

    Tuesday, September 15, 2015 6:45 AM

All replies

  • Hi Julie,

    According to your description, you are experiencing "You cannot schedule refresh for this dataset because it does not contain data model connections. You cannot schedule refresh on worksheet connections or linked tables. To schedule refresh the data must be loaded into the data model." issue when trying to auto refresh data source in Power BI, right?

    Power BI supports refresh for datasets that connect to and get data from both on-premises and online data sources. SCHEDULE REFRESH and REFRESH NOW are supported for datasets from:

    • Content packs from online data sources (content packs\services). By default, datasets from content packs are automatically updated once a day, but you can also refresh manually or setup a refresh schedule.
    • Excel workbooks where Power Query or Power Pivot is used to connect to and query data from a supported online or on-premises data source.*
    • Power BI Desktop files where Get Data is used to connect to and query data from a supported online or on-premises data source. 

    Please refer to the link below to see the details.
    https://support.powerbi.com/knowledgebase/articles/474669-refresh-data-in-power-bi

    Besides, here is a similar issue with yours and the solution was confirmed. Please refer to the link below.
    http://community.powerbi.com/t5/Integrations-with-Files-and/Can-t-refresh-a-Data-Set-from-Excel-file/m-p/2350#M660

    Regards,


    Charlie Liao
    TechNet Community Support

    Thursday, September 10, 2015 6:53 AM
  • Hi Liao,

    Thanks for the reply.

    I have gone through the links and followed the 2nd method.

    I have created an excel work book with data model. The power pivot has been copied to one drive- personal. Then I have accessed this file from powerbi.com. Still I'm getting the same error. Please suggest

    Regards,

    Julie

    Thursday, September 10, 2015 11:47 AM
  • Hi Liao,

    I am able to refresh the dataset after installing power BI gateway from Microsoft site.

    Regards,

    Julie

    Tuesday, September 15, 2015 6:45 AM