Forum Discussion
Solution: Changing datasource from Import to Direct Query -> SUCCESS
Hi all I recently wanted to change the datasource from Import to Live Query using the "Power BI service" and had a good lookaround without turning up much other than "you can not"... However ...
Getting some questions on the steps involved.
To be clear:
When I say DELETE/COPY I mean that you shall navigate INTO the .zip file (.pbix file renamed to extension .zip) with a suitable tool for the job. Also, I have found that Total Commander works nicely for this and that the buildt-in windows compression support does not play nice with the file, rendering it unusable when it is renamed back to .pbix and attemting to open it in powerBi desktop...
So; rename .pbix file to .zip extension, navigate into the file deleting and copying files as described below.
Works for me :-)