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.
Hi,
i want to copy more than 3000 cells into a power bi table.
How can i do that?
Is there a way to connect data (Data > Excel) and then leave data static in?
Thanks
Solved! Go to Solution.
After you have imported the Excel spreadsheet, then click on "Edit Queries".
From there, right click on the excel spreadsheet, and remove the check that says "Include in report refresh"
This should change the excel data to static data.
Hi,
I am having the same problem, I have a static table that I require (more than 3000 cells) but even when I mark the table to not be included in the refresh it still fails.
Any suggestions?
After you have imported the Excel spreadsheet, then click on "Edit Queries".
From there, right click on the excel spreadsheet, and remove the check that says "Include in report refresh"
This should change the excel data to static data.
already done, nothing change
If a delete excel file power bi stop works
@Anonymous You have to hit Close and Apply after unchecking "Include in report refresh". Otherwise your changes won't be applied.
Then try refreshing it will work perfectly 😉
Regards,
Etienne
You are sure, the field is unchecked?
I have just tested it from here, and my BI report is still functional after i have deleted the Excel File.
You're right.
Thanks you!
@Thim wrote:You are sure, the field is unchecked?
I have just tested it from here, and my BI report is still functional after i have deleted the Excel File.
Hi,
I'm not sure I understand your problem could you develop ?
Using Get Data>Excel does not get you what you want ?
Regards,
Etienne
No cause if you delete or move excel file BI doesn't work
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 |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |