Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a Power Bi Report that has an excel file behind which has tabs by different month.
When I refresh my data in excel with new tabs for new month, it does not refresh the Power bi Data or the new month tab does not show in my Query list on the left pane of the query window.
Also, if originally in the excel file I have 6 tabs, but I chose to select only 4 tabs. Later if I want to add the other two tabs I didn't do initially, how to do that?
Thank you!
panda
Solved! Go to Solution.
Hi @Anonymous,
One Query loads data from one Excel worksheet. Data refresh updates the existing query, reflecting the data changes in source worksheet, rather than adding new data queries automatically. If new worksheets added to source excel file, to load it to desktop, you have to create new data connections manually.
Regards,
Yuliana Gu
Hi @Anonymous,
One Query loads data from one Excel worksheet. Data refresh updates the existing query, reflecting the data changes in source worksheet, rather than adding new data queries automatically. If new worksheets added to source excel file, to load it to desktop, you have to create new data connections manually.
Regards,
Yuliana Gu
Hi Yuliana- thanks for the solution. I have a follow-up query.
'If new worksheets added to source excel file, to load it to desktop, you have to create new data connections manually.'
-- how i do that? can you fw me the steps/guides to do that? I have an excel file with multiple sheets already loaded into PBI dekstop. Now recenlty i added 3 new sheets into my excel. Now i want to load these 3 new sheets into my earlier PBI reports so that i can create a new PBI page report. Thanks in advance.
While viewing the query page (edit query of your Power Bi visual view), click New Source and choose the same Excel file. It will load with all the possible queries. It seems to treat tabs and named tables as queries. Check the boxes you would like to display. You do not need to re-check the queries already showing. However, a though is to consider using one tab, but adding a Month column so you can display the data by month. I like to include Year, Quarter and Month in all my reports. Best.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |