Forum Discussion
Service now and other data set
Hi ,
I have a requirement.
Power bi report with service now as direct query and other data come from azure data explorer.
can anybody have done this ?
like what connection is good direct query or import ?
as we are using multiple datasets how can we implement dynamic rls?
what challenges we can face in incremental refresh ?
Thanks for the help in advance..
Hi Anonymous ,
Azure Data Explorer provides three options for connecting to data in Power BI: use the built-in connector, import a query from Azure Data Explorer, or use a SQL query. This article shows you how to use the built-in connector to get data and visualize it in a Power BI report. Using the Azure Data Explorer native connector for creating Power BI dashboards is straightforward. The Power BI connector supports Import and Direct Query connectivity modes. You can build dashboards using Import or DirectQuery mode depending on the scenario, scale, and performance requirements.
To learn more details ,refer:
https://docs.microsoft.com/en-us/azure/data-explorer/power-bi-connector
Best RegardsLucien
1 Reply
- v-luwang-msft
Community Support
Hi Anonymous ,
Azure Data Explorer provides three options for connecting to data in Power BI: use the built-in connector, import a query from Azure Data Explorer, or use a SQL query. This article shows you how to use the built-in connector to get data and visualize it in a Power BI report. Using the Azure Data Explorer native connector for creating Power BI dashboards is straightforward. The Power BI connector supports Import and Direct Query connectivity modes. You can build dashboards using Import or DirectQuery mode depending on the scenario, scale, and performance requirements.
To learn more details ,refer:
https://docs.microsoft.com/en-us/azure/data-explorer/power-bi-connector
Best RegardsLucien