Forum Discussion
Can Power Query be used in SSAS?
Can Power Query be used in SSAS? Not the other way round!
I already know how to develop Power Query M scripts in Power BI Desktop that digests SQL tables, and then use these in Power BI.
I want to reuse these Power Query M scripts to develop a SSAS tabular model.
Just to avoid confussion ... please note I am NOT asking how to import a SSAS tablular model into Power Query M scripts.
I am asking how to use Power Query M scripts to create a SSAS tablular model.
Can you develop a Power Query M script in Power BI Desktop that digests SQL tables, then export the M query to a SSAS tabular model? If so how?
I have some Power Query M scripts I have developed in Power BI Desktop, but I want to create a datamart that can be share with SSRS and other queries.
I know I could re-write all the M functionality as a SSIS datawarehouse and then export that to a SSAS tabular model.
However, I wondered if there is a quicker way to re-use the Power Query M scripts I already have?
Thanks
Power Query/M is the hammer, and SSAS is the screw...
Don't do it, this is not what M is for.
1 Reply
- lbendlinSuper User
Power Query/M is the hammer, and SSAS is the screw...
Don't do it, this is not what M is for.