Hi everyone, I hope you can help me with this.
I’m using an Excel file as the data source for a Power BI report. The report itself is empty, but I’ve built a semantic model with several transformations in Power Query.
I marked a table as a featured table using a unique column, since my goal is to publish the dataset and make it available in Excel (via the Data tab), and then share it with colleagues. I’ve also promoted and marked the dataset as discoverable in the Power BI Service.
However, I’m unable to see the dataset in Excel under the Data tab.
I followed the same process about two years ago and it worked, but now it doesn’t. Does anyone know what might have changed (either in Power BI or organizational settings), or what I might be doing wrong?
Hi Javier,
The featured table is no longer available.
Go through this in order:
In Excel → Data tab → Get Data → From Fabric & Power Platform > From Power BI
Or Insert tab → PivotTable → From Power BI
Do you see the dataset?
If not:
Confirm you have Build permission
Try connecting via Analyze in Excel from Power BI Service (select the semantic model → Analyze in Excel)
If that fails ask IT:
“Is Analyze in Excel enabled?”
“Are live connections to Power BI datasets allowed?”
Confirm:
You are using Excel 365 desktop
You’re logged into the same account as Power BI
Mynda
@mynda Thanks Mynda,
That makes sense. I know that I could get the data through those ways, but the reason behind "featured table option" was because of promptness and closeness with the users. They will not have to open an specific file everytime they wanted to take a glimpse at the info I have published.
I appreciate your quick answer and I regret Microsoft taking out this feature.
The Insert tab → PivotTable → From Power BI method is the replacement for Featured Tables, so they can still get the data without needing you.
Yes @Mynda, you’re absolutely right. What I meant is that previously, with the “Featured Table” option in the Data tab in Excel, it didn’t matter which file users had open, and they didn’t need to save anything specific. They could simply type the customer name they wanted to check and instantly get an executive summary based on the data I uploaded.
With the Pivot Table approach, however, the process requires several additional steps: Insert → Pivot Table → Select connection → possibly sign in again → choose the connection type (Pivot or Table) → and then organize the data as needed.
In the end, it feels less efficient due to the number of steps involved.
This is of course if I'm understading your approach correctly.
I believe you have understood correctly.