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 guys,
Ihave like 86 millions rows in my fact along with few dimensions and i want to chage it from direct query to import i tried doing that but getting an error,
any idea how to approch this situations.
How are you trying to change it? In Data source settings, once you have a data source in Direct Query mode, I believe the Import option is greyed out. So, that question as well as what error you are getting.
this is how m changing and after loading some of the 33 millions rows am getting error like data sourse connection closed( am trying once agian if get the error again i will take a snap shot)
You may be running into a data model size limitation. What happens if you just create a brand new Desktop file and connect to the data source and do an import (could even copy over your query using Advanced Editor)
Hi @aka,
You'd better check if the error was caused by the size limitation according to @Greg_Deckler posted. Please feel free to ask if you have other issue.
Best Regards,
Angelia
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 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |