Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi
I am using Power BI at work. A Power BI dashboard was created by an user and now I got control over the dashboard. However, the source data excel file for Power BI dashboard is still not accessible and it is routing to the system where other user works. Due to this, I am unable to make changes to Power BI dashboard as source data file is unavailable in my system. We tried sharing the file by email, Teams, Sharepoint, yet when I make changes to data , it is not reflecting on the dashboard. We observed that the user who created dashboard, when he made changes to data in his system, the changes were reflecting.
I am wondering how we could resolve this issue as I cannot keep bugging my colleague to make changes in the file to refelct on Power BI dashboard.
Any suggestion on this would be greatly appreciated.
Thanks
Hi @VijayanandN
It seems that you are working on a copy of the data, that's why the changes are not showing.
I would start a new.
I presume that there are transformations made in the original query, so we need to now just to change the source of teh original query.
If there are no transformations made to the original Excel, please do the following
If there are transformations
let
Source = Excel.Workbook(Web.Contents("https://yourcompany.sharepoint.com/sites/BI/Doucuments/.xlsx"), null, true),
hope this helps
Kind regards
Joe
If this post helps, then please Accept it as the solution
User | Count |
---|---|
43 | |
26 | |
22 | |
20 | |
17 |
User | Count |
---|---|
54 | |
45 | |
24 | |
24 | |
21 |