Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
I'm wondering if anyone can help me understand an error message?
I've been tinkering wth the composite models functionality, when i connect to one of my datasets (with direct query), all of the measures within that model do not work and are flagged with the following error message:
"Cannot find data source 'DirectQuery to AS - [DATASET NAME]' in function 'EXTERNALMEASURE'
So far i have:
- Been able to connect to other datasets without issue
- Experience the same issue when connecting to this particular dataset, and this dataset alone using DQ
- Experience the same issue if i publish the dataset to another workspace
- In all scenarios i am able to recreate the measure, by writing it again, without issue and with expected results
DesktopVersion: 2.88.1144.0 64-bit (December 2020)
It feels like an issue with the dataset, i don't understand the error message well enogh to know what the problem is, particularly the EXTERNALMEASURE bit
thanks
- jeroenterheerdt
ok, so can you give a bit more detail about the dataset in question? What source is it? Can you open the same dataset in Live connect mode without any problem? Can you share an example measure that is not working?
