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.
HELP! I created and have been successfully using my PBI reports for a few months. Today, I went to refresh my visualizations and am stuck on the below item "Creating connection in model..." I've waited over an hour for this to finish (usually it takes 10 seconds) and it will not complete. I rebooted my PC, downloaded the latest version of desktop none of which helped. I went into my queries and manually refreshed the previews, all of which have succeeded....my updated data is displaying in the queries but it just won't refresh the visualizations. All of my data is pulled from excel spreadsheets....and I manually refresh it. How do I get past this issue?
Solved! Go to Solution.
Figured it out on my own...one of my source files went from 6,520KB to 33,000KB for no reason. Onof the spreadsheets contained within went from 45 columns to just about every column populated with something (even though the columns appeared blank). Once I deleted the "blank" columns, my file went back to its former size and the refresh succeeded with no issue.
I am encountering the same problems...
I import only one table (17,986,280 rows) from ssas server, but it's stucking in "Creating connection in model" for near half an hour. Also, I've exmained the table which has no blank columns. is it normal? or any experience to check the problem efficiently? Thanks a lot!
Figured it out on my own...one of my source files went from 6,520KB to 33,000KB for no reason. Onof the spreadsheets contained within went from 45 columns to just about every column populated with something (even though the columns appeared blank). Once I deleted the "blank" columns, my file went back to its former size and the refresh succeeded with no issue.
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 |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
65 |