Forum Discussion
Solved
How do I change a query from Import to Direct Query?
I have a SQL Azure database that I can use Direct Query with for a new PBIX file. selecting the tables to load allows me to check the edit button and convert to Direct Query. However, I have previous...
Hi Anonymous and diverdown1964, i had commented on this question in another thread:
Hope that helps.
BR
Hi Anonymous and diverdown1964, i had commented on this question in another thread:
Hope that helps.
BR
I know this thread is a little bit old, but for anyone looking to do this I was able to partially achieve this. It seems if you go into the Power BI Desktop Query editor, remove the old table and reimport it then when you apply the Dataset updates it will prompt you. It appears you need to re-add your relationships, but at least it's not starting from scratch.