Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I'm receiving weekly reports in Excel format from a client, and I set up a Power Automate flow that copies the attachment to a SharePoint Library, after renaming it. My dashboard then pulls this data, and we are all happy. However, I noticed today that because the sheet is named differently every week, Power BI fails in the navigation step. I can rename the Excel workbook on Power Automate, but I cannot rename the sheet. I am curious whether I can do that on Power Query instead. See below, screenshots that show the applied steps and what happens in the navigation step. What I want to do is to change Source to something generic like "Sheet1". Is that possible?
Thank you,
Solved! Go to Solution.
Hi,
if you have only 1 sheet in your workbook you can try deleting the navigation step and then expand Data column
Otherwise you can also try to modify the navigation step
= Source{[Item="Sheet1",Kind="Sheet"]}[Data]
to a generic one:
= Source{0}[Data]
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi,
if you have only 1 sheet in your workbook you can try deleting the navigation step and then expand Data column
Otherwise you can also try to modify the navigation step
= Source{[Item="Sheet1",Kind="Sheet"]}[Data]
to a generic one:
= Source{0}[Data]
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
This was just what I was looking for regarding an issue I had with dynamic worksheet names!
Thanks, @serpiva64
Your suggestion to change it to a generic one is ingenious and, of course, it worked!
Thank you,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |