PBI Dataset not working in excel.

[ROG]

Hi guys,

I'm unable to refresh my excel report which is using a PBI Dataset connection. It's fine if I create the same report on service, but for some reason in excel it keeps spinning until I get the error message below. Can you help?

Thanks!

[v-shex-msft]

Hi @ROG,

I'd like to suggest you take a look the following link about the limitation list about get data from power bi dataset if they meets to your situations:

Connect to datasets in the Power BI service from Power BI Desktop - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng