Forum Discussion

prakhar's avatar
prakhar
Frequent Visitor
9 years ago
Solved

Import Table created using DAX into Power BI Query

I have some tables imported from different sources into Power BI using M. I have only learnt DAX expressions propoerly till now. I created a new table using DAX expressions directly. Now, I am try...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Actually it is possible!  But in a really round about way which I don't recommend.

     

    Using Get Data use can specify Analysys Services as your source.  If you have DAX Studio you can find the port number your PBI Desktop model is listening on.  Simply connect to Localhost:63410 (or whatever port number your model is currently on)

     

     

    You can then use your DAX tables as data sources to import in.  Each time you open/close PBI Desktop the port number will change and you'll have to manually update it which is where it falls apart. 

     

    So it's ok for one off work but no good in reality.  Mostly interesting.

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Actually it is possible!  But in a really round about way which I don't recommend.

 

Using Get Data use can specify Analysys Services as your source.  If you have DAX Studio you can find the port number your PBI Desktop model is listening on.  Simply connect to Localhost:63410 (or whatever port number your model is currently on)

 

 

You can then use your DAX tables as data sources to import in.  Each time you open/close PBI Desktop the port number will change and you'll have to manually update it which is where it falls apart. 

 

So it's ok for one off work but no good in reality.  Mostly interesting.

 

prakhar's avatar
prakhar
Frequent Visitor
9 years ago

Thanks for the workaround. For this time I will rewrite my queries. But it might come in handy when there are too many queries to be rewritten.