Forum Discussion
PBILover
3 years agoHelper V
synapse Query Folding
Hi, I have a cosmos db as a background and i am using Synapse through which i am accessing this cosmos DB data in a power BI . I have created some views in a Synapse and Accessing those views in a ...
Greg_Deckler
3 years agoCommunity Champion
PBILover According to this: Power BI data sources - Power BI | Microsoft Docs Azure Synapse supports DirectQuery (hence query folding) while Azure Synapse Analytics Workspaces do not (no query folding). Which one are you using?
- PBILover3 years agoHelper V
Thanks for the reply Greg_Deckler , Its working now. I am using synapse Import mode.
- TokwaGraph2 years agoAdvocate II
May I ask, how did you get it to work?
I'm at a similar situation. Where Data Engineering provides me with views in Azure Synapse to connect to. But even on the 1st step of my Pquery (the server selection step), I immediately see the "view native query" greyed out. What's going on?