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?
Direct query has restrictions. Behind the scenes it converts the query into SQL and there are limits on that. I'm no SQL expert but you could possibly write an SQL query that does the unpivot and then use this technique hatfullofdata.blog/using-sql-on-dataverse-for-power-bi/
@@HatFullOfData123 🥰 Thanks a lot for your answer and link. Its great to know this. This could be a best solution for my goal to have live data using Dataverse instead ImportMode in Power BI..Let me try this.
With this approach, the columns are unfortunately given the logical name and not the display name. Is there a way to use the display name? Without renaming the columns manually
Power BI make easy data to shown. Very good data presentation tool.
understandable and very helpful! kudos to you!
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?
Direct query has restrictions. Behind the scenes it converts the query into SQL and there are limits on that.
I'm no SQL expert but you could possibly write an SQL query that does the unpivot and then use this technique hatfullofdata.blog/using-sql-on-dataverse-for-power-bi/
@@HatFullOfData123 🥰 Thanks a lot for your answer and link. Its great to know this. This could be a best solution for my goal to have live data using Dataverse instead ImportMode in Power BI..Let me try this.
With this approach, the columns are unfortunately given the logical name and not the display name.
Is there a way to use the display name? Without renaming the columns manually