Forum Discussion
Executing a SQL server query in power BI
I need to execute a sql server query in power bi. I know this isn't how it is generally done and PBI recommends writing queries in M query, my hand is kind of forced in this. I have an expressi...
hi, Anonymous
You could use SQL server query in the connector as below:
And for your case, I would suggest you use writing queries in M query.
https://docs.microsoft.com/en-us/powerquery-m/datetime-localnow
Best Regards,
Lin
hi, Anonymous
You could use SQL server query in the connector as below:
And for your case, I would suggest you use writing queries in M query.
https://docs.microsoft.com/en-us/powerquery-m/datetime-localnow
Best Regards,
Lin