The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I'm connecting the Power BI report to a tabular cube, live conn, and we have some columns defined as date in the cube but in PPower BI report are shown as text.
Is there a solution to see as date also in Power BI?
In the cube:
In Power BI:
Thanks,
Irina
Solved! Go to Solution.
@salexa , Can you check if this shows it as text in the column tools or only the symbol is missing. I have doubts about the custom format. is happening with default format too
Hi,
You are right, only the symbol is missing. I've test it with slicer and it has the date options.
Thanks!
Hi @salexa ,
Is the DATE column in cube in dd/mm/yyyy or some similar format or is it a UNIX Timestamp date or a date value having timezone appended to it like 21/11/2021 UTC ?
It will be nice to have some screesnhot around data values that you see in Cube and in Power BI not just data-type.
Thanks,
Pragati
@salexa , Can you check if this shows it as text in the column tools or only the symbol is missing. I have doubts about the custom format. is happening with default format too
Hi,
You are right, only the symbol is missing. I've test it with slicer and it has the date options.
Thanks!
User | Count |
---|---|
109 | |
82 | |
74 | |
53 | |
49 |
User | Count |
---|---|
133 | |
97 | |
94 | |
71 | |
69 |