python or R visualizations when using DirectQuery?

[priya1988nath]

is it possible to use python or R visualizations when using DirectQuery?

Thanks

[TomMartens · Accepted solution]

Yes!

Regards,
Tom

[priya1988nath]

@TomMartens , thank you for your response. do you have useful references/ links on this topic?

[TomMartens · Accepted solution]

Hey @priya1988nath,

I recommend this article as a start for data visualization using R: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals and this article for data viz with Python: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals.

The nature of the data viusalizations does not depend on the mode of of the dataset, meaning it's independent of the dataset is in import mode or direct qurey mode.

Due to limitations of R and Python data visualizations regarding. interactivity and compatibility with the latest supported R/Python runtimes and the supported packages I always recommend the Deneb visual instead. The Deneb visual integrates the vega and vega-lite javascript libraries, here you will find more information about the Deneb visual: https://deneb-viz.github.io/

Hopefully, this provides what you are looking for.

Regards,

Tom

[TomMartens · Accepted solution]

Yes!

Regards,
Tom