Forum Discussion
SQL Server and PowerBI DirectQuery mode
Hi all, I have a client masterfile table included in my data model. The table is linked in DirectQuery mode from a SQL Server. In the table query I have added some lines to mock up the data but w...
Hi there, thanks for your reply.
I did actually try the first method above and it did not work. After adding the new column I couldn’t populate it conditionally and got the same message. I will try the second solution (If I can find the way). At the end if nothing works I will accept the import mode but we are talking about a very large table to be possibly used in several reports and would be a real waste of space.
Many thanks indeed; I will let you know how it goes.
Regards,
C.