Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have a many questions of SQL Server and Power BI:
1/ I want to study table staging in SSIS.
2/ SSIS can call store procedure, views of source database or destination database?.
3/ SSAS can call store procedure, views of destination database from fact table?
What's version of of SQL Server and Power BI support it?. Could you help?. Thank you.
In the cloud version of D365FO you have no access to the prod database. Not with Power BI, SSIS or SSAS. Do you have cloud or on premises version?
Yes, I will use cloud version, not on premises version.
In cloud version you don't have access to SQL. Could you please explain whats your requirement? Did you explore option of using BYOD for power BI reporting ?
As expert mentioned in below comments that you don't have access on SQL of cloud D365FO Production. I believe here you are talking about Data warehousing & PowerBI reports. for this purpose you can BYOD, Via this you can bring your production database to any AZURE/Local(Public IP) SQL instance. where you can perform your activity.
Business Applications communities