Create PivotTable Report by Connecting to Power BI Dataset
HTML-код
- Опубликовано: 5 май 2020
- In this video tutorial, we see how to connect to PowerBI Dataset to Create PivotTable Report in Excel. This feature is currently available to the Microsoft 365 InsidersFast. If you enjoy the video, do subscribe to my RUclips channel for more educative videos.
For more Excel and PowerBI tutorials, visit
www.exceljetconsult.com.ng/blog/
This is really cool. I was able to get this working in an insider's build. Would there be anyway to combine data from a dataset with some external data like an Excel workbook or a table from another DB? I assume that wouldn't be possible until they release the feature for composite models over datasets, but I thought I would ask anyway.
Hello Sir, Good Day, I created a date hierarchy and tried to use it in excel pivot, it is throwing an error saying "can not create the hierarchy because it is not processed" could you please suggest what to do?
Do you know if the connection will use Row Level Security if it has been defined in the Power BI Dataset? Assuming that user will only be able to connect to Power BI service if they have it activated on their O365 licence and will only see the Datasets (Workspaces) that they have access to. Thanks.
Hi Nice video. Couldn't this be all done in only PowerBi?
Hello Roderick. This is actually a new feature in Excel that allows users to use their dataset in PowerBI to create PivotTable in Excel..
Hi I am not able to see from power bi option in get data nor in pivot table
Hello Ashwini,
The feature is only available in Beta Channel of Excel for Microsoft 365/Office 365. So, you might not have it if you're not on Beta Channel.
Regards
Good day sir. I just tried this and there is no option for PowerBI on my excel. What am I missing?
Good day Bhomane... The feature is only available in the Beta and I think, Current Channels of Excel for Microsoft 365..
Hello Abiola, I am using Version 1908 but connect to Power BI is not available??
Hello Farman, the feature in currently available to Microsoft 365 Insiders program. It's not yet available to Monthly, Annual and Semi-annual channels.
If you're on Insiders, you can easily click on Update Now. Then, you will have it.
Cheers
@@Abioladavid01 thank you dear