Forum Discussion
Using Power Query to append a Dataset & Analysis Services
JKFX001 Switch to DirectQuery for Power BI Datasets instead of Live and then you can create a composite model that allows you to do what you want.
Greg_Deckler thank you! I was able to switch the live connection on the dataset to Directquery by going to File > Options & Setting > Options > Preview features and selecting 'DirectQuery for PBI datasets and AS".
However, when I try to add the data from Analysis Services it tells me;
"Either the version of Analysis Services is too old, or the admin disabled DirectQuery connections to this data source".
Is this something I should address with my data team or am I trying to add this additional data incorrectly?
I ask because as I have the dataset open via DirectQuery, I see that there is still no option for the Data view where I would append the data together once added.
Any advice is welcome.
Thank you
JKFX001 Not sure if that error is related to your source system or Power BI Desktop. But, you should be able to go into Power Query and, for example, create an import mode query. That then makes the dataset a composite model.
Use composite models in Power BI Desktop - Power BI | Microsoft Docs