Query dataset in Power BI service using M

[KiranKr]

I want to populate a streaming dataset with the data from a dataset that exists in Power BI service. Can someone please suggest M code to use in Power Shell to connect to a dataset in Power BI service? Thank you.

[dax · Accepted solution]

Hi KiranKr,

According to your description, it seems that you want to  expose "M" as a stand-alone module, which could be called in c# or PowerShell, right? If so, I suggest you could post this requirement in power-bi-ideas or vote on  Make PowerQuery ETL a scriptable language targeting more than Excel and PowerBI

By the way, you also could refer to Is there any way to invoke PowerQuery/M outside of Excel or PowerBI? for 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.