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
well,In the Power BI service we can publish report from Power BI Desktop and improt our report and data set into the service and we can also press on "get data" .I need to know ,when we "get data" ,is the service contain the same structure as Desktop ,I mean it has its Power Query,Power Pivot and Power View ? and where is the Direct query exactly ,it is a manner to interoge database and how it take place .
I deal with a technical research about Power BI and I need details of operations so I hope you help me.
Hi mouna I think you are on the right track.
Simply put the Direct Query runs on the server rather than within the PowerBI program. - see here https://msdn.microsoft.com/en-us/library/hh230898.aspx
PowerQuery exists within PowerBI and you can write queries to develop things like date tables and source data.
Power View is a microsoft excel addin - I wouldn't bother with it - everything is moving to PowerBI and I imagine it will be discontinued soon.
Power Pivot is an excel addin as well - takes the same DAX language as Power BI.Rgds
ED