Forum Discussion
Direct Query and Enterprise: migrating from import
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.
Hi mouna
There are a few ways to connect to data in Power BI. Direct Query is simply looking directly at the database - no modelling is done in Power BI. All the information is sucked directly down from the database (this is just a simple explanation). Benefits are that the data is accessed in real time so you will see more accurate information. Import only allows eight updates a day. Limitations with Direct Query at the moment mean only some basic measures can be written on the data. I understand this is changing so hopefully will see some improvements soon.
Best to start with the helpful information
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-to-data/
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
ED
Hi, I first created a visualization using direct query, but faced issues when i try to publish it, through i already have the personal gateway running. When i try to change the direct query to import, the import is dimmed out. i have no way to choose import even if i try a new connection to the same file. Any clues? i need to convert this to import. and i have a lot of tabs already configured and working fine. the data is same no change except it imports.