Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Switching data source from Direct Query to Import Mode

Hi

 

I have a report that is using 2 different data sources, both from Microsoft Azure. Both are currently running as Direct Query but I would like to change one of them to import.

 

I can't figure out how to swap one to Import without swapping both.

 

Any guidance would be greatly appreciated.

 

Thanks

Victoria

Need Help
  • dax's avatar
    dax
    7 years ago

    Hi VictoriaQ,

    You could try to change this like  below(Click View->check Field Properties, then set storage mode like below)

    You could refer to Storage mode in Power BI Desktop for more details.

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi VictoriaQ,

    You could try to change this like  below(Click View->check Field Properties, then set storage mode like below)

    You could refer to Storage mode in Power BI Desktop for more details.

    Best Regards,

    Zoe Zhi

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.