Power BI desktop connected to dataflow with blank table

[annatan]

Hi, 

I have a technical question I hope you can help me with.

I recently joined the company and started building some Power BI reports. As part of this, I created a few dataflows with computed tables. From my understanding, computed tables consolidate data from linked tables. When I set them up, I received a message that premium capacity is required for refresh.

While the approval for premium capacity is still in progress, I tried connecting to these computed tables, but the result was blank tables. Could you please confirm whether, once premium capacity is enabled, I should be able to access and refresh these dataflow tables as expected?

This is my first time encountering this scenario, so I would appreciate your confirmation.

Thank you,

[v-karpurapud]

Hi @annatan 

Just checking in as we haven't received a response to our previous message. Were you able to review the information above? Let us know if you have any additional questions.

Thank You.

[annatan · Accepted solution]

Once premium capactiy is granted, problem is resolved. 

[v-karpurapud]

Hi @annatan 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[Shahid12523]

Without Premium capacity, computed tables in dataflows show up as blank because they can’t refresh. Once Premium is enabled, those tables will refresh properly and display data in Power BI Desktop as expected.

[annatan]

I hope it will do after I gain my premium capacity access. Thanks,

[v-karpurapud]

Hi @annatan 

Thank you @Royel  and @Shahid12523  for sharing helpful insights.

Were you able to try accessing the computed tables after your Premium capacity was enabled? If the issue still persists, please share more details so that we can assist you further.

Regards,

Microsoft Fabric Community Support Team.

[Royel]

Hi @annatan  Yes you're correct. Computed tables in dataflows require Premium capacity to refresh and work properly. When you create computed tables without Premium capacity, they will appear blank when connecting from Power BI Desktop because they cannot refresh or load data.

References: 

https://learn.microsoft.com/en-us/power-query/dataflows/what-licenses-do-you-need-in-order-to-use-da... 

"AI capabilities in Power BI, linked table, and computed table are all premium functions that aren't available with a Power BI Pro account."

For limitations: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitation

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!