Forum Discussion
Resolver IDirect Query limitations vs Import
You should be able to create a composite model these days (directquery and import) depending on what version you are using and what data source you are using for DirectQuery:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
Look at the end to see incompatible data sets.
But, yes, Power BI does not support certain functions in DirectQuery mode. See this page:
Community ChampionYou should be able to create a composite model these days (directquery and import) depending on what version you are using and what data source you are using for DirectQuery:
https://docs.microsoft.com/en-us/power-bi/desktop-composite-models
Look at the end to see incompatible data sets.
But, yes, Power BI does not support certain functions in DirectQuery mode. See this page:
Resolver IThanks Gregg. I'll review what you sent when I have a moment.
By the way, you may not recall but months ago I asked for ideas on how to promote PBI in my organization over Tableau. You provided me some ideas. It's been a battle but I've had success institutionalizing PBI. If I can be successful with PBI Report Server I think it will spell the end for Tableau in my organization. I'm in Commercial Development and have our CCO and CFO's support. Thx as always for your help!