Forum Discussion

ScottKC's avatar
ScottKC
Frequent Visitor
3 years ago

Some PBI Datasets not showing in Excel

I'm working on a PoC to test using PBI Datasets within Excel (both Excel Desktop and Excel for the Web) and I'm getting mixed experiences that I can't isolate/resolve. Most datasets aren't available ...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi ScottKC 


The datasets that you cannot see, are those imported PBI Datasets or are they SSAS Tabular datasets?

 

All datasets have to be imported into the PBI Service to be available via Excel Online/Excel.

ScottKC's avatar
ScottKC
Frequent Visitor
3 years ago

A few are AS (Scenario2, Model Dataset test1, SSAS test1) and the rest are imported.

 

Initially only "Global Consolidated" was available in Excel, yesterday I tried adjusting the Endorsement on "Scenario1". It didn't have any immediate impact to availability, however today (12+ hours later) it is now available via Excel for the Web.