Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Solved! Go to Solution.
Hi , @AlessandroBet
If your data source is a dataset on the powerbi service,that is equivalent to the connection mode of liveconnect and you cannot create a calculate table or calculate column.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#live-connections
You also can refer this related article:
Best Regards,
Community Support Team _ Eason
I believe you want:
#Margin_Table = DATATABLE("Mounth",STRING,"Margin",CURRENCY
,{
{"Jan",100},
{"Feb",200},
{"Mar",300}
}
)
Yes sorry i did a mistake typing. Anyway it doesn't work
Hi , @AlessandroBet
You also can refer here.
And could you please tell me whether your problem has been solved?
If it is, please mark @Greg_Deckler replies or add your reply as Answered to close this thread.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I can select "new table".
My dataset is linked and not create by myself
Hi , @AlessandroBet
If your data source is a dataset on the powerbi service,that is equivalent to the connection mode of liveconnect and you cannot create a calculate table or calculate column.
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#live-connections
You also can refer this related article:
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
90 | |
71 | |
68 | |
53 | |
27 |