We are getting datasets in Power BI by using Power BI datasets with live connection method. We want that dataset to be connected to Azure SQL database. Is there any way to do so ? Please share a link.
We are getting datasets in Power BI by using Power BI datasets with live connection method. We want that dataset to be connected to Azure SQL database. Is there any way to do so ? Please share a link.
Hi @ShrutiSrivastava-6707 Thank you for posting your question. You can use Power Query Online connected to Azure SQL to achieve the above. This documentation explains this in more details with step by step.
Please let me know if that answer your question.
Regards,
Oury
Hi @ShrutiSrivastava-6707 Just Checking if the above answer helped solve your issue. If yes, Please accept answer as it will be useful for other community members facing the same. Otherwise let us know how we can better assist you. Please also refer to this Power BI blog for more details Direct query for Power BI Datasets and Azure Analysis Service(Preview)
Hope that help
Regards,
Oury
10 people are following this question.