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 ...
I had to do this again today, went fairly smoothly.
I found you can now skip the SOURCE file altogether. Just rename the TARGET file as a zip, and using Total Commander delete the "Datamodel" file, and rename it back to a .pbix extension.
Then when you open it in Power BI Desktop, the Fields pane will have a link to "Get data". Use that to choose your Power BI Dataset.