Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to change from import query mode to DirectQuery mode but the directquery mode is queryed out from the data model view. See screenshot below:
I tried to go through the source to change it but it is not available, see screenshot below
Then, I tried to go through the file Options setting but it is not appearing. see screenshot below
I really don't know why I can't convert to Direct Query. Please help
Solved! Go to Solution.
Hi @Anonymous ,
Due to many features in Import mode is not supported in the Direct Query mode, it’s not possible to switch from Import Mode to Direct Query Mode.
If you want to modify the connection mode in this pbix, try the following:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , As far as I know, You can not change from import to direct query.
You can change from a direct query to import
Is there any reason why?
Hi @Anonymous ,
Due to many features in Import mode is not supported in the Direct Query mode, it’s not possible to switch from Import Mode to Direct Query Mode.
If you want to modify the connection mode in this pbix, try the following:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @V-lianl-msft
thanks, what about all the measures ?
if your graph is showing measure ? so you shoud recreate all the measure from the beginning ?
i have more than 200 measure in my app, there is a way to export them ?
Thanks
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |