Change DAX on Connected Excel Tables from Power BI

[JoachimSA]

Hi folks,

the Power BI Blog recently announced this new feature which I am really excited about.

There is mention of the underlying DAX being exposed in the Properties of the connection.

Of course I immediately tried to change that DAX to a totally different statement that I build and tried using Tabular editor on the local PBIX.

Somehow, though, the results between the query I build locally in TE3 querying the local model and this connected excel table loocing at the identical online model do not match.

Is changeing the DAX not supported ? Are there limitations or additional filtering I am not aware of ?

Thanks and best regards,

Joachim

[JoachimSA]

Indeed we did have some problem in our dataset producing inconsistent results.

Now the Next Question if I could have this connection as a Power Query in my excel file... this would be amazing! Any thoughts on that ? I think I will open a new threat on that.

[GilbertQ · Accepted solution]

Hi @JoachimSA 

I would imagine that the query is either not identical or the data you have in your PBIX is not the same data that you have in your Power BI Service model?

You could try use DAX studio where you can run the same query on your PBIX and your Power BI Dataset (if in PPU or premium)