Forum Discussion

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Power BI with Azure SQL Data Warehouse

When connecting from PowerBI service to Azure SQL Data Warehouse does it make and keep it live connection or it imports data into PowerBI ?   To give background on this issue, our requirement is to...
Need Help
greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Yes. There are two options for accessing data from Azure DW in Power BI. One fits your requirements. One does not.

 

DirectQuery = Data stays in source system. Power BI Service generates a query, which is evaluated against that source, the results of which are piped securely to the client running the report.

 

Data Import = Data lives with the .pbix file, and is hosted on Microsoft servers running Power BI.

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

Thanks greggyb and ashishrj for the reply.

 

DirectQuery is the one that suits us.