Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
I've contacted Microsoft about this and also tried to dig through the forums here, but I haven't quite been able to find the solution for this question.
Here is my problem:
1)
I am using Sharepoint where I created an XLS with data. This XLS file is used as an action log for all sorts of different projects, therefore the file gets updated regularly whenever someone makes a new entry for an assigned task.
2)
I then created a Power Bi dashboard using my desktop version and I have connected the XLS from the Sharepoint to the Power Bi. (= source file: XLS from Sharepoint)
3)
I then published the Power Bi dashboard and I embedded the report in a website link which I have shared with those people who need to access the dashboard to see the status of various tasks on the action log.
4)
When I now enter new rows in the XLS source file as described above, and I then open and refresh the Power Bi dashboard, the dashboard isn't showing any of the updates. So say if there were 10 open tasks when I first published the report, and I then added a new row to the underlying XLS, my Power Bi report should now show 11 open tasks after refresh. But it does not.
Can someone explain to me what is going on? The whole point of me using the XLS from Sharepoint (and not some local file) as the source file was so when I publish the Power Bi dashboard and people make changes to the XLS, that these changes are then automatically reflected in the Power Bi web report. But the refresh doesn't do anything at the moment.
Right now, I have to open the Power Bi locally on my desktop, refresh my data there, and then publish the updated report again... which is exactly what I don't want to be doing.
What I want is this:
1) I create the Power Bi ONCE and publish it ONCE
2) When someone adds more rows to the XLS on sharepoint (which is connected to the Power Bi) I want these changes to be reflected in the Power Bi dashboard upon hitting refresh without me having to do any more manual steps.
What am I doing wrong here? I thought the whole point of publishing a report was to be able to keep it up to date more or less automatically whenever someone enters additional data into the source file?
I would really appreciate if someone could explain to me what it is I am currently doing wrong and how I can make this work.
Many Thanks!
Solved! Go to Solution.
@Anonymous Right, so if you hover over the Refresh button for a report in the Service, it clearly states that it is refreshing the visuals and is not refreshing the dataset. To schedule a refresh, go to a workspace page, Datasets + dataflows and click on the ellipses for the dataset in question. Then choose Settings. You will see an area there for creating a refresh schedule.
Second question, technically a "dashboard" is a different thing than a report. You are using a report. You can pin visuals from multiple different reports to a Dashboard in the Power BI Service. It has its uses.
@Anonymous So this could be a variety of things but the most likely is that you need to setup scheduled refresh for your report/dataset. Using the "refresh" in the Service simply refreshes the visuals on the page if the dataset has been updated, it does not kick-off a refresh. Also, if you are using an actual Dashboard and not calling a report a dashboard then it could have something to do with how you pinned your tile.
Hi again,
I think I found the issue. I didn't see the little red triangle pop up whenever I clicked on "refresh dataset". Turns out for whatever reason I had to refresh my credentials again. I added scheduled refreshs every 3 hours and my dashboard now refreshes as intended when I refresh the dataset.
Just one more question on this topic: Is there any way of having the dataset refresh more regularly?? I found the option for scheduled refreshes, but you can only choose up to a max. of 8 different times per day.
Is there any way of having the dataset refresh itself every time a new entry is made? Or at least like once every 10 minutes or so?
Thanks for the quick reply.
Two questions on this then (I am relatively new to Power Bi)
1)
How is a scheduled refresh different from the "normal" refresh, and how do I do a scheduled refresh? I thought the only reason for scheduled refreshes was in case I didn't want to hit the button manually, but from what you're saying it sounds like the refresh button I see on my dashboard in the web version has nothing to do with refreshing the dataset (like when you hit refresh on the desktop app)?
2)
"Also, if you are using an actual Dashboard and not calling a report a dashboard then it could have something to do with how you pinned your tile."
I admit I'm not sure what you mean by that sentence. Could you please elaborate? My original steps were this:
1) hit "publish" on my local power bi
2) open the report in my Power Bi workspace
3) Went to "file" - "Embed report" - "Website or portal"
4) Share the link with the necessary people
@Anonymous Right, so if you hover over the Refresh button for a report in the Service, it clearly states that it is refreshing the visuals and is not refreshing the dataset. To schedule a refresh, go to a workspace page, Datasets + dataflows and click on the ellipses for the dataset in question. Then choose Settings. You will see an area there for creating a refresh schedule.
Second question, technically a "dashboard" is a different thing than a report. You are using a report. You can pin visuals from multiple different reports to a Dashboard in the Power BI Service. It has its uses.
Thank you so much for your quick help!
Just for clarification: So let's say I create 3 different reports that use entirely separate source files but are loosely related in some sense. What you are saying is that I could take multiple visuals from those 3 different reports and display them as a single dashboard (as if they were "one")?
So a person opening a web link might think all the data comes from one report/one source file when in reality it combines multiple separate reports?
Where do I do that? I would love to try that out but cannot find anywhere.
Many Thanks again!
@Anonymous Correct, as long as all of those reports are in the same workspace. So, to do that, open your report in the Power BI Service. Hover over a report visual and in one of the corners you will see a "pin" icon. Click that and pin it to a new dashboard. Then you can pin other report visuals from the same report or other reports in the same workspace to that dashboard as well. And, bonus, when you view the dashboard and click on a tile, it takes you to the underlying report by default!
**bleep** this is brilliant. I will surely use this feature in the future as I will eventually have to combine different visualizations.
Thank you so much for the explanation
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
50 | |
35 | |
30 | |
14 | |
12 |