Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
I have installed Power BI excel publisher and and it is working fine. I can see all the published dataset and reports name from excel. But when trying to open a report (Built in Power BI) in excel, it says you don't have any calculated measure in thi report. I does show all the fields in data set as Power Pivot fields.
so my question is : Can we view the reports in excel which are created in power BI desktop, published on power bi webservice ?
Thanks.
Solved! Go to Solution.
Hey,
using the add-in "Power BI Publisher for Excel" in Excel allows to connect to datasets hosted in the Power BI Service.
One feature is to connect to Power BI Report as a datasource instead of using a dataset. But unfortunately this doesn't mean your are able to watch or even better to interact with the Power BI reports.
It just means, it allows to connect to the dataset used by a report, this might be different from a "native" dataset due to the fact that it's possible to define measures upon a direct query or live connection dataset.
Hopefully this clarifies something
Regards
Tom
Hey,
using the add-in "Power BI Publisher for Excel" in Excel allows to connect to datasets hosted in the Power BI Service.
One feature is to connect to Power BI Report as a datasource instead of using a dataset. But unfortunately this doesn't mean your are able to watch or even better to interact with the Power BI reports.
It just means, it allows to connect to the dataset used by a report, this might be different from a "native" dataset due to the fact that it's possible to define measures upon a direct query or live connection dataset.
Hopefully this clarifies something
Regards
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.