Realtime Data Reporting using Dataverse & Power BI

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

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

50% 1

This video will walk you through the process of how to use Power BI for real-time data reporting using Dataverse. Power BI is a really powerful tool that can help you get insights into your data faster than ever before.
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#Dataverse
#PowerBI
#DataReporitng

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

20 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@surender665 Год назад

Hello Sir, Please help me, I want to import data from apache druid database but not found any options to connectivity. Please suggest me.

@KeaPointTechTips Год назад

Never tried it. Sorry.

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

Any course you can recommend from beginning to end.. For power BI..

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

There are few really good course on the Udemy website. Have a look. It really depends on your skills set. The Udemy have courses from beginners to advanced users.

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

@KeaPointTechTips 28 дней назад

Hi, I have not tried this myself with unpivoting. I will give it a go and may create a video on this topic if I find any solution.

@madhanrajmoorthy8843 28 дней назад

Thank you for your answer and efforts on that. Looking forward for that video 😊

@KeaPointTechTips 27 дней назад

I don't think there is currently a clean way to unpivot a table using DAX. However, it is possible to achieve a similar result, but you'll need fairly need to manual code. For example, to unpivot your bottom table, you could write a union like this: UNION( SELECTCOLUMNS(Targets, "Segement", Targets[Segment], "Qtr", "Q1", "Target", Targets[Q1]), SELECTCOLUMNS(Targets, "Segement", Targets[Segment], "Qtr", "Q2", "Target", Targets[Q2]), SELECTCOLUMNS(Targets, "Segement", Targets[Segment], "Qtr", "Q3", "Target", Targets[Q3]), SELECTCOLUMNS(Targets, "Segement", Targets[Segment], "Qtr", "Q4", "Target", Targets[Q4]))

@madhanrajmoorthy8843 27 дней назад

@@KeaPointTechTips Thank you so much for your script. Yes, I tried this way earlier. it worked. Currently, I found a way DV Table -> SSMS(Unpivot in SQL) -> Added SQL in Power BI as a Query with SQL while loading. Then I got the unpivoted data, then I was able to do transformations as DirectQueryMode itself.

@KeaPointTechTips 26 дней назад

Good to know that you found a work around.