Forum Discussion

misc981's avatar
misc981
Frequent Visitor
1 year ago
Solved

Create table from Direct Query PBI datasource

I have a PBI report that pulls data from multiple PBI datasources.  Have since discovered that it is not possible to transform data from these datasources in Power Query.   I am contemplating creat...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    You can’t transform or create new tables in Power Query when using PBI datasets as DirectQuery sources.

     

    Options:

     

    Use composite models → connect multiple PBI datasets, create relationships & measures.

    Create calculated tables with DAX (limited).

    Push summarization upstream in the source dataset.

     

    You cannot materialize/transform tables inside PQ with DirectQuery datasets.

     

    Best practice: Pre-aggregate in the source dataset, then consume in your report.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

You can’t transform or create new tables in Power Query when using PBI datasets as DirectQuery sources.

 

Options:

 

Use composite models → connect multiple PBI datasets, create relationships & measures.

Create calculated tables with DAX (limited).

Push summarization upstream in the source dataset.

 

You cannot materialize/transform tables inside PQ with DirectQuery datasets.

 

Best practice: Pre-aggregate in the source dataset, then consume in your report.