There are four sections in the Power BI service: Dashboards, Reports, Workbooks, and Datasets
What is a Workbook ? What is it used for?
Solved! Go to Solution.
There are a couple of different uses. You can pin tables and graphs from the excel doc to dashboards. While you can't schedule automatic refreshes you can hit reload and and it will refresh any changes you made to the file in excel online (One Drive works the same). I currently use it to pin a few graphs from an excel file for reports that I have to manually update because I do not have premium so I don't have access to incremental refresh so I manually update the file and it updates the pie chart that is pinned to a dashboard with other various relevant data. Not ideal, but pretty handy.
The excel workbook also functions as part of the data set so you can use tables in it in the report. I haven't messed with this because If I was going to do this I would just add the file as a source in the pbix before uploading, but I'm sure it has some utility. I just prefer to keep my auto refresh stuff and my manual refresh stuff clearly separated.
You can pin something to the dashboard once you have it in Power BI service. How do you get Excel file into Power BI service Workbooks? There are no active buttons and/or links in there.
Here is the tutorial on getting excel workbooks into the workbook grouping in Power BI: https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files
And here is the tutorical on pinning parts of it to a Power BI Dashboard: https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-tile-from-excel
If this helps please kudo.
If it answers your question please accept it as a solution.
Is it possible to schedule the daily situation of a dataset in a workbook?
Day1 : creation of workbook based on a copy of data set on current day
Day2: creation of another workbook based on a copy of datset on current day
In other word i want to do a snapshot of my dataset (once a week maybe) and save it in a workbook, can i?
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!