Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all,
I have a question with which I am struggling for some days already. I have a Power BI dataset which is connected to Dataverse via the Azure SQL connection. I am using Direct Query as the connection type because the client needs to see data in real-time.
So far, everything is working fine but there now is a new requirement which is about displaying projects with a start and end date on a timeline (they have a capacity which should be shown for every date the project is going).
I have a table which is structured similarly to the following model:
Now, the goal is to show data in the following format so that I can connect it to the existing date table:
So far, I have been using approaches similar to the following:
However, since I am using Direct Query now, there is no option for me to create a custom table and I can also not create a custom column in Power Query as I did in other projects.
Does anybody have an idea on how to accomplish that? The data source unfortunately does only provide the format of the first image.
Would be great if you could help me with that. I appreciate any answer!
Solved! Go to Solution.
Hi @Anonymous ,
It is no possible to create a custom table in DirectQuery mode, but you can create a table during calculation, like summarize().
Expression you can refer this as below:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
It is no possible to create a custom table in DirectQuery mode, but you can create a table during calculation, like summarize().
Expression you can refer this as below:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , I have used a measure approach
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |