Forum Discussion

speedramps's avatar
speedramps
Super User
5 years ago
Solved

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

  • Power Query/M is the hammer, and SSAS is the screw...

     

    Don't do it, this is not what M is for.