Forum Discussion

jessicaf31's avatar
jessicaf31
Advocate I
10 years ago

Schedule Data Refresh Issues - Power BI desktop

Hi everyone,     I have manually refreshed successfully a set of data  (in green in the screenshot) but when I want to schedule the Data Refresh, it is written (in French sorry) that the last refr...
Mykhael's avatar
Mykhael
Kudo Kingpin
10 years ago

I see, OK the second step is chek your gateway on your computer, please go into your control panel, then select programs, and delete the power BI gateway, then install it again. After doing that open the Power BI gateway and log in.

 

Sometimes that issue is produced by your Computer Gateway, let me know if works... I will be checking this conversation. You can dowload the Power BI gateway here Follow this link

 

Best

 

jessicaf31's avatar
jessicaf31
Advocate I
10 years ago

Mykhael I have done exactly what you told me to do...

but the row is still in grey... :( 

 

  • Mykhael's avatar
    Mykhael
    Kudo Kingpin
    10 years ago

    No worries jessicaf31, What is the sourse of your data?, Is an excel file the source of this report?, I need that information to understand why you are recieving this error.

      • Mykhael's avatar
        Mykhael
        Kudo Kingpin
        10 years ago

        Hi jessicaf31,

         

        I found some information about it,

         

        .

        Power BI Desktop file with data from an OData feed

        In this case, you use Get Data in Power BI Desktop to connect to and import census data from an OData feed. You create several reports in Power BI Desktop, then name the file WACensus and save it on a share in your company. You then publish the file to your Power BI Site. In this case, you can manually refresh the data in the WACensus dataset or setup a refresh schedule. Because the data in the data source comes from an OData feed online, you do not need to install a Power BI Personal Gateway, but you will need to go into the WACensus dataset’s settings and sign in to the OData data source. You can then setup a refresh schedule so Power BI automatically connects to the OData feed and gets updated data. Your reports and dashboards will also be updated automatically. Link here

         

        Limitations in OData feeds exposed by Power BI’s Data Management Gateway

        Some users encountered confusion about when to use OData feeds with Power BI’s cloud data refresh, since SQL data sources against the Data Management Gateway (DMG) feature of Power BI allow exposing the data source as an OData feed directly. Link here

         

        Let me know if this is helpful for you, if is not, I recommend to open a ticket to the power BI team and they can assist you. https://support.microsoft.com/en-us