Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Shaunbuckleyy
Regular Visitor

Creating Reports from Published Datasets - No Data Table view

Hi, 

I am trying to create a report for a published dataset & even though I am the admin I do not have a view of the Data. Does anyone know if that is just a restriction with creating a report from a published dataset even if you are the admin? 

Shaunbuckleyy_0-1695904403966.png

 

Any help would be much appreciated 🙂

1 ACCEPTED SOLUTION

Hello @Shaunbuckleyy ,

 

well because the data is in a seperate file and you're just reading from it then you can't view it unless you open the file having the data.

 

It's not about the access type, being an admin or a viewer or a member , its just the data is stored in another place.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

5 REPLIES 5
Shaunbuckleyy
Regular Visitor

This makes sense & is good to know. Thanks @Idrissshatila 🙌

audreygerred
Super User
Super User

Hello! Correct, when you are utilizing a live connection you will not see the data/table view. You would need to open the pbix file for the data model or download it from service.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Idrissshatila
Super User
Super User

Hello @Shaunbuckleyy ,

 

You need to download the power bi file that has the published dataset so you could see the data view.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




This seems strange that an Admin cannot have a view of the data when they want to create a seperate report from a published dataset (without having the original one opened). Is there no way around this? Maybe this is what dataflows help with?

As an example, I created a KPI Report for a client and I want to build a Financial Statement report using the same dataset, surely there is a way I can do this & view the data without having to open or download the KPI Report?

Hello @Shaunbuckleyy ,

 

well because the data is in a seperate file and you're just reading from it then you can't view it unless you open the file having the data.

 

It's not about the access type, being an admin or a viewer or a member , its just the data is stored in another place.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.