Excel connection to some semantic models not working since last week

[Sperling]

Sometimes I make a simple dataset with data from our staging layer for specific unique usecases that can't currently be supported by our star scheme semantic models.

Since our users don't have access to this raw data, I create a semantic model with what is needed, add a refresh schedule with my credentials, and the users then connect to the semantic model in Excel.

This has worked fine for a long time, but last week someone said what I made for them was missing in Excel.

When I look myself in Excel, it is also missing - but when I look in PBI Desktop, it is there to connect to.

The extra weird thing is, I can still connect using Excel to one of the older models I've made - exact same data source, exact same settings, exact same permissions (wouldn't matter though since I have admin/owner access to it all).

[Json_Mobily]

This is awesome! it works! thanks for this tip!😃

[lbendlin]

can you pinpoint an exact date?

[Sperling]

Unfortunately not. I was made aware friday and its still an issue today.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[Sperling]

Appreciate it. I've opened a ticket. I'll update here in case other people run into the issue.

[Anonymous]

Hi @Sperling ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yilong Zhou

[Sperling · Accepted solution]

Hi Yilong,

I "solved" it last week. As some of you may have seen Excel had a visual update when connecting to PBI datasets, and my issue came at the same time. Before you could just search and your dataset would show up - now you need to press enter after searching.

Silly change, but solution is as simple as pressing enter and I feel a bit stupid.