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.
Hi,
I have an Analysis Service Query as following where I am querying a SSAS table called - Chart of Accounts like following
AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/XYZ", "Price Accuracy_dmOnly", [Query="EVALUATE Chart of Accounts", Implementation="2.0"])
and it returns the following errror
DataSource.Error: AnalysisServices: Query (1, 16) The syntax for '<pii>of</pii>' is incorrect. (<pii>EVALUATE Chart of Accounts</pii>).
However, if I delete the space in the table name and change it to CoA and query, it perfectly works
AnalysisServices.Database("powerbi://api.powerbi.com/v1.0/myorg/XYZ", "Price Accuracy_dmOnly", [Query="EVALUATE CoA", Implementation="2.0"])
I would not have mind doing this manually if it was for a small number of tables. But I am querying almost 15 SSAS tables for a new analysis and I don't want to change the table name manually in the model cause it might break something somewhere else.
Is there any way to handle space for SSAS table name in the query window itself.
Thank you in advance.
Solved! Go to Solution.
You can try putting quotes around table name
e.g. EVALUATE 'Chart of Account'
Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
@sayaliredij it worked, sorry could not update you earlier, thanks !!!
You can try putting quotes around table name
e.g. EVALUATE 'Chart of Account'
Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |