Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Visuals not refreshing with sharepoint connection

I have an Excel-file that I want to visualize in Power BI. It is located on Sharepoint, so to get it into Power BI, I simply copied the link to the file on sharepoint, removed everything past the .xlsx, signed in with my office account, and then clicked connect. I have built a great report, and it has also been published to a workspace. 

 

Today I changed some of the data (marked some rows with X) in the excel, and since the dataset in the workspace is on manual refresh, I clicked refresh there too. Then I went into the report, clicked on refresh visuals, but I still couldnt see a change. 

When I go into the desktop app, I can click refresh and see that I get the latest data on my visuals, but it dosen't work in Power BI service. Only when I published the report to the workspace again did the report in the workspace show the latest data. 

 

Does anyone know what's up with this?

 

The dataset in the workspace has sheduled refresh disabled due to the following message:

Data source error: Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh.

Maybe this has to do with the problem I described earlier, but how would I fix it then?

 

Thanks for your help! I really appreciate it 🙂

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

    When you publish the report created in Power BI Desktop to the Power BI Service, you need to set the data credentials for the dataset in the Power BI Service, because Power BI need access the data source with this credential and get the latest data from data source.

    Please set your data credential in dataset->settings->datasource credentials.

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

  • MukeshT's avatar
    MukeshT
    New Member
    3 years ago

    For that, we have created a power bi report using an excel sheet. Then, we will publish the report online in the power bi service.

    Open Power Bi desktop, Now you can see the report page on the power bi desktop.
    Now we will publish the report on the web. To publish the report, click on the publish icon on the ribbon on the power bi desktop.
    In the Publish to power bi dialog box, under select a destination, click on the My workspace. Click on the Select
    Then in the Publishing to Power Bi dialog box, you can see that your power bi report(financial report) successfully published on the power bi web. Then click on Got it.

    Now we will schedule a refresh in the power bi service, when we make a change in the report on the power bi desktop, it gets updated on the web.

    In the office 365 admin center, Click on the app launcher, then select power bi.
    Click on the My Workspace from the navigation in power bi service.
    Then go to Dataset+Dataflows on the My workspace page in the power bi service.
    Next to the name of the dataset, there is a refresh now icon, by clicking on the refresh icon, you can refresh the report immediately.
    Next to the refresh now icon, click on the schedule refresh in the My workspace page in power bi service. Here we are using the financial report to set the schedule refresh.

     

    Regards,
    Mukesh