cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
astevens
Advocate II
Advocate II

Invalid report

"There is no dataset associated with this report. Please open the settings pane of the report and pick a dataset to bind the report."

Invalid report.JPG

Over the last couple of weeks my end users have been reporting this message when they attempt to view reports. If I share the report with them again, sending an email notification, they can open the report through the email link, but they cannot open the report within the service itself, under their "Shared with me" section. They get the "Invalid report" message for about 8 out of 10 reports they try to open.

 

I've checked the Settings/Datasets/Gateway connection and they all appear to be active and consistent across both reports they can open and reports they cannot. Lost as to what to do.

9 REPLIES 9
odebadwar
Frequent Visitor

Hi @astevens Did you find any solution? I am facing the same issue with the shared workspace as well. I cannot migrate my reports to some other workspace because I have alot of members in the workspace. Your response is highly appreciated.

 

Thanks.

I did not find a solution. I moved a lot of my reports to a workspace and people using that workspace don't seem to be having any problems. But other reports I keep in the "Shared with me" section for users because they are sensitive or user specific. I just share the link with people again if they have a problem. 

 

From what I can tell, the only solutions are:

 

1) Create workspace(s) for user(s) and share whichever reports you want which specific users to see based on which workspaces they can access

2) Use the usual sharing option from "My workspace" and when users have an issue reshare the link with them

2a) Related to 2), it might be possible to have all of the report links in a shared document and then users could click into them from there, but I haven't tried that so not sure if that works.

spiritofme
Advocate II
Advocate II

I have been getting the same thing in various workspaces ever since the new sharing thing was started. Which incidentally is soooo confusing!

v-luwang-msft
Community Support
Community Support

Hi @astevens ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
 
Best Regards
Lucien
v-luwang-msft
Community Support
Community Support

Hi @astevens ,

I fount the same error in this post:

https://community.powerbi.com/t5/Service/Couldn-t-load-the-schema-for-the-database-model/td-p/148011

 

Wish it is helpful for you!

 

Best Regards

Lucien

 

mohammedadnant
Responsive Resident
Responsive Resident

Hi @astevens 

 

Do they have access to that Dataset workspace..? is it on the report or dashboard..?

 

Thanks & Regards,

Mohammed Adnan

I don't have the reports in a particular workspace (just the one listed as "My workspace") and I share each of the reports with each individual user. So for them it shows up in the "Shared with me" section of the online service. These are all shared as type= Reports. I don't have them put into dashboards.

 

Thanks for the response. It gives me the idea to maybe try making a specific worksplace which I can add users to instead of sharing with them all individually. 

Hello @astevens 

 

We can also share the reports from My Workspace here are few things that you much know before going forward.

 

Workspaces are better for collaboration than My Workspace because they allow co-ownership of content. You and your entire team can easily make updates or give others access. My Workspace is best used by individuals for one-off or personal content.

Now, imagine you have a finished dashboard you need to share with your colleagues. What's the best way to give them access to the dashboard? The answer depends on a number of factors.

  • If colleagues need to keep the dashboard up to date, or need access to all the content in the workspace, add them to the workspace as Members or Contributors.
  • If colleagues just need to view the content in the workspace, add them as Viewers.
  • If colleagues just need to see that dashboard and not all the content in the workspace, you can share the dashboard with them directly.
  • If the dashboard is part of a set of dashboards and reports that you need to distribute to many colleagues, then publishing an app is likely the best choice.

 

Workspaces contain all the content for a specific app. When a designer creates an app, they bundle together all the content that is necessary for that app to be utilized. Content may include dashboards, reports, and datasets. Not every app will contain these three pieces of content. An app may contain only one dashboard, or three of each content type, or even twenty reports. It all depends on what the designer includes in the app. Commonly, app workspaces shared with business users don't include the datasets.

 

Users should have the access to the workspace and dataset.

 

Regards,

 

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!

Hi @astevens 

 

Yes, this is best practice to create a separate workspace and share them via APP.

 

Please give kudos (hit the like button) to my answer.
Thanks & Regards,

Mohammed Adnan
Learn Power Platform for free: https://www.youtube.com/c/taik18

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!