Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
99 | |
90 | |
85 | |
74 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |