Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This seems more complicated than it should be.
I am connected to a local model of a dataset. There is a table "SALES" with a column "CUSTOMER". I select New Table under Modeling ribbon.
Solved! Go to Solution.
Hi @DonRitchie ,
Please note: SELECTCOLUMNS function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Alternatively, you can try import mode to connect data.
For more information, please refer to: SELECTCOLUMNS function (DAX) - DAX | Microsoft Docs
Best Regards
Hi @DonRitchie ,
Please note: SELECTCOLUMNS function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Alternatively, you can try import mode to connect data.
For more information, please refer to: SELECTCOLUMNS function (DAX) - DAX | Microsoft Docs
Best Regards
How do I import a dataset I don't have access to alter?
Please select import option. Then you can use DAX without limitations.
@DonRitchie , Try like
DATE = summarize(SALES,"Customers", SALES[CUSTOMER])
My suggestion would be better get from database as import , using SQL in advance connection option
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |