Hello, I am unable to test this scenario as I do not have my dev environment available yet, and have been unable to find any info on a similar use case to this point...
My requirement is to create a report in Power BI, which will contain data from two different sources:
1) Dynamics 365 OData connector, to get data from D365 Entities
2) Azure SQL DB
Then, I hope to embed this report somewhere in Dynamics 365... assuming that is generally possible, what are my options -
- can this be done in a workspace?
- can I create an entirely new page and embed it there?
- can I create a new menu-item under "Reports" to link to a new page that contains the embedded report;
- or if I cannot create new page to embed, can I link to a workspace containing the report from this menu item?
I have read many articles that refer to this being possible when using D365 data entities as the source, however, no info about embedding reports where the data source is NOT from D365, or where the source is a mix of D365 and another but combined in one PBI.
Could anyone verify if this is possible? And any restrictions or info I should be aware of for this scenario?
Thanks in advance.
