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, 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)
?
Anonymous
You could write a Chrome Extension or something similar in Javascript and use Angular to programatically click the the dataset on the far left-hand side menu in the Power BI Service, and then have it click the Refresh Now option that appears from the popup menu, at a certain interval. Then you would need the refresh button clicked similarly in the actual report itself.
https://github.com/DMiradakis/Power-BI-Real-Time-Slideshow
I created a Real-Time Slideshow Chrome Extension that accomplishes this (see link above), assuming you can get your Import Queries converted to Direct Queries. If you can't, you could try creating what I described above. Javascript should be able to get you there.