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 am trying to create a new report based on a excel file which has 128 Kb.
When I try to import it to PowerBi, I can select the worksheet I want work and the next step is to apply query changes.
So, the Creating connection in model step is taking a long time.
I already unchecked Auto Date/Time and Allow data preview to download in the background. But no success.
Does anyone have any idea about a way go solve it?
@leosrs wrote:
Hi,
I am trying to create a new report based on a excel file which has 128 Kb.
When I try to import it to PowerBi, I can select the worksheet I want work and the next step is to apply query changes.
So, the Creating connection in model step is taking a long time.
I already unchecked Auto Date/Time and Allow data preview to download in the background. But no success.
Does anyone have any idea about a way go solve it?
Do you mean that the data is loaded fine to advanced editor and it keeps spinning forever when you click apply change? How many rows are there and is there any specific tranformation you did on the data?
I hope you guys don't mind me hijacking this thread as I have the same problem. Compared to OP, I have 2 Excel files whose file size sum up to 1.39 MB. Power BI has been trying to create a connection to the model for the past 8 minutes as I'm typing this which I find to be unusually long. Is there any way to fix this without me having to delete the dataset?
Yeah, mine loaded a lot of empty columns as well. I just "deleted" the empty columns from the source data and it seems to have loaded just fine.
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 |
---|---|
105 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |