Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data changes in Sharepoint not being reflected in PBI

Hi,    I have a dashboard which has as source an excel file located in sharepoint. I made a small number change in the excel file but this one is not being reflected in the PBI. In excel- sharepoi...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

In Power BI, can you try closing and opening the report and refreshing the data.
Also, you can try it navigate to Power Query and reconnect and refresh the data source fromm Power Query.
Also make sure the data coming in Power Query or Power BI is not getting filtered in anyway.
To do this create a new page and plot some columns in a table visual from the Excel table in Power BI.

Thank you. 
If my answer helps you, please mark it as solution. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for your suggestions, however, it is not getting updated yet!


    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello. 
      Can you make another Excel file in SharePoint and store only that record which does not show in Power BI. 
      Import that Excel file in Power BI. And check whether or not the data is being shown now or not.

      PS: Might be a weird suggestion but try this.
      Thank you.