Connect Dataverse to Power BI Tutorial

Подписаться 225 тыс.

Просмотров 25 тыс.

50% 1

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...
~-~~-~~~-~~-~

Опубликовано:

22 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@shamf6624 Год назад

Thankyou so much for sharing this. I looked at multiple videos but could not find the details you provided for enabling refresh💐

@steventhawe1598 Год назад

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. 🤣🤣🤣🤣

@nijamkhan1 2 года назад

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.

@raj4sss 2 года назад

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

@jegaveerpandian 2 года назад

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.

@sebastiendebosscher Год назад

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?

@jegaveerpandian 2 года назад

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!

@rosiedjurovic 2 года назад

Hi, did you ever find a solution to this? I am having the same issue

@jegaveerpandian 2 года назад

@@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.

@rosiedjurovic 2 года назад

@@jegaveerpandian thank you, I found this now - an easy one to miss!

@jegaveerpandian 2 года назад

@@rosiedjurovic indeed! I too felt the same way.

@madhanrajmoorthy8843 Месяц назад

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?

@David-rb2qz 2 года назад

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?

@PragmaticWorks 2 года назад

That's strange. No I only encountered that in the early days of Dataverse connectors for Power BI.

@DebayanKar7 Год назад

how can you edit the dataverse sources using parameters ?

@gerfer6261 3 года назад

👍👍👍

@valentinloghin4004 3 года назад

Superb video !! What is the cost of using Datavers and PowerApps?

@PragmaticWorks 3 года назад

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.

@BrunoTheBrUuu Год назад

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?

@matthewjohnluca Год назад

sad that there is a limit of 80mb on table. can u do a guide with xrmtools?

@jt3o5 5 месяцев назад

Have you ran into an issue where a date table didn’t work with direct query?

@adamsheldon3790 2 года назад

It's not working!!!! It wont let me forget mu tenant which I connected to. Plz help :L

@PragmaticWorks 2 года назад

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

@reachDeepNeuron 2 года назад

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