Forum Discussion

MikeGanem3's avatar
MikeGanem3
Helper I
1 year ago
Solved

BI Service Report not Displaying Updated Data

I have created a report in Desktop that connected to an Excel file in OnDrive, then I "Published" it to "My  Workspace". When I "Refresh" it manually, it does not bring in the updated data and the "...
General Comment
Need Help
  • v-priyankata's avatar
    v-priyankata
    1 year ago

    Hi MikeGanem3,
    Can you please try below points, this may help you.

    1. Ensure that your Excel file is linked through the OneDrive URL in Power BI Desktop and not a local path—Power BI will only be able to authenticate it appropriately.

     

    2. Verify your workspace permissions in Power BI Service. You must be an Admin of the workspace to modify data source credentials.

     

    3. Attempt to re-publish the report to My Workspace in Power BI Service. If Edit Credentials remains greyed out, remove the dataset, reconnect with the OneDrive link, and re-publish.

     

    4. Ensure you're working with the most current version of Power BI, verify the dataset settings in Power BI Service, and if still experiencing issues, clear your browser cache and cookies to eliminate any browser problems.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    Happy to help!
    Priyanka.

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi MikeGanem3 Please try updating your credentials try these please 

  • Update Credentials:

    • Go to Power BI Service → "My Workspace" → Dataset settings.
    • Under Data source credentials, click Edit credentials.
    • Select OAuth2, sign in, and save.

  • Enable Scheduled Refresh:

    • In the dataset settings, turn on Scheduled Refresh and set the frequency.

  • Verify OneDrive Connection:

    • Ensure the Excel file is connected via its OneDrive URL in Power BI Desktop (not a local path).
    • Re-publish the report if necessary.

 

 

MikeGanem3's avatar
MikeGanem3
Helper I
1 year ago
  • Under Data source credentials, click Edit credentials.   This option is greyed out in my case.
  • v-priyankata's avatar
    v-priyankata
    Community Support
    1 year ago

    Hi MikeGanem3,
    Can you please try below points, this may help you.

    1. Ensure that your Excel file is linked through the OneDrive URL in Power BI Desktop and not a local path—Power BI will only be able to authenticate it appropriately.

     

    2. Verify your workspace permissions in Power BI Service. You must be an Admin of the workspace to modify data source credentials.

     

    3. Attempt to re-publish the report to My Workspace in Power BI Service. If Edit Credentials remains greyed out, remove the dataset, reconnect with the OneDrive link, and re-publish.

     

    4. Ensure you're working with the most current version of Power BI, verify the dataset settings in Power BI Service, and if still experiencing issues, clear your browser cache and cookies to eliminate any browser problems.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    Happy to help!
    Priyanka.