Wonderful... We can validate the data in Excel itself...great thanks for the sharing...
@PragmaticWorks2 жыл бұрын
Glad you enjoyed!
@saloriasaxon73232 жыл бұрын
You guys are the greatest here and love the videos very much!
@PragmaticWorks2 жыл бұрын
Glad to hear that!
@reubensiwela34482 жыл бұрын
Thank you, i love your energy and how you explain
@PragmaticWorks2 жыл бұрын
I appreciate that! Thanks for watching!
@zohrashikhiyeva31672 жыл бұрын
VERY USEFULL ! THANKS FOR SHARİNG!
@PragmaticWorks2 жыл бұрын
Glad you enjoyed!
@no_name5002 Жыл бұрын
Great stuff. If I send the excel file (already connected to PowerBI) to a colleague, Would that colleague be able to refresh him/herself?
@Jonathon_Silva Жыл бұрын
That colleague would need to have access to the Power BI dataset, either in the workspace or if it was shared with them. They would then be able to refresh the Excel workbook and PivotTables, but not the actual full dataset that was published in Power BI - which would have to be done in the Power BI service.
@sylau15162 жыл бұрын
Thanks. Very clear explanation. One question - how to fresh the data or reconnect back to the same dataset? Thanks.
@Jonathon_Silva2 жыл бұрын
The data will be refreshed inside the model at Power BI service. This can be done manually, or with a scheduled refresh.
@AllenRose Жыл бұрын
Hi Jonathon, Is this "Analyze in Excel" feature available in "PowerBI Desktop" as well? great work.
@evelic Жыл бұрын
What about if this gets very slow when using it in excel? Currently dealing with that issue using a model of around 600,000 rows data set and 4 demension tables filtering it.
@evelic9 ай бұрын
Probably you need to request more capacity for your worskapce with your IT team.
@Anurita_10042 жыл бұрын
Can I save this excel sheet on my desktop for further use.
@Jonathon_Silva2 жыл бұрын
Absolutely, you can save this sheet just like you would with any other excel file!
@Anurita_10042 жыл бұрын
@@Jonathon_Silva okay, thanks for letting know.
@AlTincu Жыл бұрын
Thank you. Is it possible to connect to a report instead of a dataset? I use a shared dataset(created by others) and I add measures, then pubblish the report. When i try the Analyze in excel, i don't have my measures, but only the ones existing already in the dataset.
@vishalmalpure6008 Жыл бұрын
Hi, i am also looking for the same solution. Kindly let me know if you were able to got through on this . Will be really helpful ! Thanks
@divyagandala69292 жыл бұрын
I have a pro license, and have downloaded "Analyze in Excel", but still i can see it is disabled
@AllenRose Жыл бұрын
From where have you downloaded the "Analyze in Excel"? Thanks!