Forum Discussion

calebsg's avatar
calebsg
Frequent Visitor
10 years ago
Solved

Direct Query and Enterprise: migrating from import

How do I change a data source from Import to Direct Query?   I have installed the Enterprise Gateway and have no idea how I can modify the queries in the pbix file to point to the Enterprise Gatewa...
Need Help
  • Bjoern's avatar
    Bjoern
    10 years ago

     

    calebsg, elliotdixon

    As far as I know, it does not work. And think about it, there is a good reason to that:

     

    - What to do, if you have changed the model in your file after the import?

    - Or other way around: What do you do, if the server changed a lot, but your local model did not? A lot of conflicts would come up.

    - Further, please note that in the "imported"-model, you can model the relationships yourself and also the data structure etc.. This would get ripped apart, if you use the direct query.

     

    My recommendation:

    Rebuild it. Power BI reports are created pretty fast and the application has improved a lot since July/August.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, I have the same issue - I would like to change a little query from data taken by SQL but I also would like to always have data up-to-date in Power Bi Service.

As I understand - I cannot rebuilt query when getting data by DirectQuery so need to use Import.

 

Is that mean that (using Import) every time to refresh visualisation I would have to:

1. open pbix file in Power Bi Desktop,

2. Refresh its,

3. save file,

4. Publish (by replacing existing one)

?