Connect Dataverse to Power BI Tutorial
Vložit
- čas přidán 25. 07. 2024
- Learn how to build a Power BI report to gather real-time data out of the Dataverse (CDS). Find out how to find the Environment URL that will be required for Power BI and how to find your tables. Also learn some of the basic differentiations in Choice and Choices columns in Dataverse and how that impacts your reports.
Pragmatic Works Training and Hackathons: www.pragmaticworks.com
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~
![Column and Field Security in Power Apps Dataverse [Tutorial]](http://i.ytimg.com/vi/S6SZu8uhKOo/mqdefault.jpg)
![Column and Field Security in Power Apps Dataverse [Tutorial]](/img/tr.png)
Thank you so much Brian. a week ago I faced an issue with tracking Golf Strokes and Result from a canvas app and publishing them to a power bi report. I used import when connecting to the Dataverse tables as such I had to manually refresh in order for the scores to be live. 🤣🤣🤣🤣
Thankyou so much for sharing this. I looked at multiple videos but could not find the details you provided for enabling refresh💐
Hi, It is very nice Video, I have any query like I have used DataVerse and built the reports as well, now i came across to change the Data source settings for I could not able to where my reports was built in Datavaerse. It will be great helpful if any idea.
Hi, great video...thanks for sharing the valuable information...
I am facing the 80 mb limitation with dataverse direct query, could you please suggest to over come the issue
Hi, I too had this issue. I have removed the additional columns created by dataverse and just used/direct query my 'custom' columns in the table and it worked for me. Not a great solution but worth a try. all the best.
Hi, Great one Thank you.
However, power BI is not allowing me to unpivot the data that comes from DataVerse table. If I unpivot, it immediately notifies to move to Import Mode. But I want it in DirQuery mode. Do you have any ideas to solve this issue?
I'm having issues with power query retrieving a table in dataverse with over 100'000 records (read impossible). What are the limitations?
Is synapse link the recommended way to go if I have more than xxxxx (?) records?
Great video, thank you so much! I have implemented security role for a dataverse table and used power bi to build a report on that. when I publish the report in to workspace the security role (from dataverse) doesn't apply there. Any thoughts on how to make that happen (make the security role in dataverse in reflecting in power bi work space) other than implementing row level security in power bi report. Appreciate your comments, thank you so much!
Hi, did you ever find a solution to this? I am having the same issue
@@rosiedjurovic Hi, when publishing the report, there will be a pop up window asking whether the RLS should be applied to the data from dataverse.
@@jegaveerpandian thank you, I found this now - an easy one to miss!
@@rosiedjurovic indeed! I too felt the same way.
how can you edit the dataverse sources using parameters ?
👍👍👍
Have you ran into an issue where a date table didn’t work with direct query?
Superb video !! What is the cost of using Datavers and PowerApps?
It's included when you license Power Apps but you can also license it separately. Each user you license includes either 50 or 250MB of space based on the license you purchase.
Great video! I have a problem though... Power bi desktop doesn't import the relatioship between tables from dataverse. Have you ever encountered this kind of problem?
That's strange. No I only encountered that in the early days of Dataverse connectors for Power BI.
sad that there is a limit of 80mb on table. can u do a guide with xrmtools?
Recently Microsoft started suggesting to put a man in the middle, between DataVerse and PowerBI, to overcome Dataverse connector limitations.
The man in the middle is Azure Synapse Link ... Can you telll us a little bit more about that?
It's not working!!!! It wont let me forget mu tenant which I connected to. Plz help :L
Sure, you can purge that cached settings by going to File --> Options and Settings then Data Source Settings. Then purge whatever connection you want to kill. -Brian
its literally crazy thing.... to connect to dataverse why to much of roundabout way of doing it ??? also if you could have briefed about what the hell data verse and why it is used would have been much hepful