Connect D365 FnO Tables to Microsoft Fabric Lakehouse
Hi Community, Uisng Link to Fabric i am connecting my dynamic 365 finance and operation tables to Microsoft fabric lakehouse, but i am not able see those tables in the lakehouse i.e., it shows active in power apps link to fabric but when i go to Fabric workspace where i am trying get these tables it shows some error like shown in the below screenshot Can anyone in the Community provide some help to resolve this error and say what is this error about and how can we resolve it.Unable see the Tables in Fabric that have status as active in Power Platform.
Hi Community Using Link to Fabric in Power apps i have synced my D365 FnO to Fabric lakehouse there are some tables that have status as active in power apps as show in screenshot below but are found in Unidentified folder in Fabric lakehouse what might be the reason behind it and how to solve this problem. The above two screenshots one is from power apps and the other is from Fabric lakehouse Can any one in the commuinty provide the solution for this problem any small information provided will be so helpfull.
Developing Dashboards from FnO Data
Hi, I am developing Power BI Dashboard in Fabric. My flow of Data is from, FnO to Dataverse to Microsoft Fabric (As Shortcut Tables, here data is not present in OneLake, It is present in Dataverse Environment). My Requirement is to Develop a dashboard on top of it. I have came to know about two methods: 1. Using SQL End-Point - Creating a visual query, choosing specified columns, replacing values, etc.. and then saving as a view (The required view alone saves in OneLake). If needed we can also create a measure for the same in SQL EndPoint. 2. Using Notebooks on Lakehouse - Using a Notebook, loading tables as df, making transformations and then saving the same (Here the transformed gets saved in OneLake) (We can run notebooks at specified intervals, such that once data gets refreshed in Dataverse, it gets refreshed in Dashboard). Is there any common persona to use, both Replace Feature (From SQL Endpoint) and the New Calculated Column Feature (From Warehouse). I would like to know about the Warehouse Method, where I can get like the below mentioned image. If possible, I would like to know if I should use all the tables in OneLake or is there any way to use the transformed tables alone in OneLake. (I have taken this image from Semantic Model) Below image is for Visual Query in SQL Endpoint Kindly assist me with all the possible ways and the solution of creating measures, calculated fields, etc.. all possible solutions with SQL Endpoint Notebooks and Warehouse methods, since fabric is a fresh perspective. And, if I bring my data into datawarehouse using the "+" options, will that cause storing data into OneLake, or the same will come as a Shortcut tables (I believe data doesn't gets duplicated into OneLake here) Any Assistance on this will be highly helpful. Thanks in Advance.
