cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sure19 Regular Visitor
Regular Visitor

Re: Direct Query and Enterprise: migrating from import

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.

simonroyjones Frequent Visitor
Frequent Visitor

Re: Direct Query and Enterprise: migrating from import

If you have 3 options down the left hand side (Report Design, Data View, Relationships) then it is imported.

 

If only two (no data view) it is direct query.

zico Occasional Visitor
Occasional Visitor

Re: Direct Query and Enterprise: migrating from import

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)

?