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.
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)