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.

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi misc981,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you Shahid12523 for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi @misc981,

 

We wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi @misc981,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa