Forum Discussion
Datavarse to Power BI
Hi anandmanurkar - Power BI does not directly support connecting to Dataverse views as a data source; it connects to tables.
Open Power BI Desktop and select Get Data > Power Platform > Dataverse.
Sign in to your Dataverse environment and choose the table corresponding to your view.
Import or DirectQuery mode: Choose based on your need to handle large data volumes and refresh requirements.
Or using
FetchXML is an excellent option for accessing and transforming Dataverse data in Power BI while avoiding the limitations of direct table connections. FetchXML provides a way to pull data exactly as defined in a Dataverse view, including filters, sorting, and column selections.
Hope this helps.
Many thanks for your response, The video on your YT only shows how to downlod xml, can you suggest way to import it to PBI. I tried using XML but it dose not get me data as i see in my DV View