Dataset in My Workspace not showing up in Report Builder

[olimilo]

I have several datasets published in My Workspace but they don't seem to be showing up in Report Builder when selecting a dataset. I have a Pro license.

There is another post that has the same issue but there were no solutions found: https://community.fabric.microsoft.com/t5/Service/PowerBI-Paginated-Report-cannot-see-Dataset-in-MyW...

Any idea how to fix this?

[BI-Leo · Accepted solution]

You can find these Semantic model Under Shared with me in the Report Builder, but I don't know why this is such weriod.

[olimilo]

Thanks! I agree, this seems like an oversight from the developers to put the My Workspace datasets under the Shared With Me list.

[BI-Leo]

Yes. But best practice for developing a Paginated Report through a corporation level is to put DataFlow or Semantic model under a Premium workspace, then you can switch your Connection string or data source by creating rules in the Deployment pipeline. If no Premium workspace, then it's fine.

[v-yaningy-msft]

Hi, @olimilo 

Based on your description, you can't see the dataset published in My Workspace in Power BI Report Builder. In fact, Power BI Report Builder is a paged report related application, regardless of whether you are connecting to My Workspace or another Workspace, you will only see paged reports. If I misunderstood what you meant, feel free to ask any questions about this.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[olimilo]

The issue is: I cannot find the datasets/semantic models published in My Workspace to use with PBI Report Builder (desktop application).

If you look at my screenshot, there are 2 datasets published in My Workspace (left window). In the select PBI Dataset dialog box (right window), My Workspace is not listing any datasets. The question then is: where are the datasets I published in My Workspace and/or how can I use them with PBI Report Builder without publishing to a different workspace?

[AnkitKukreja]

Hi @olimilo 

Extracted the below solution from the post you have shared.

Here's a list of what you need and don't need to use a shared dataset in Power BI Report Builder.

• Download and install Power BI Report Builder.
• The dataset can be in any workspace, and you don't need to be a member of that workspace.
• To access a Power BI dataset, you need to have Build permission for the dataset. Read about Build permission.
• You need a Power BI Pro license or Premium Per User (PPU) license to publish your paginated report.
• You don't need a Power BI Pro or PPU license to create a paginated report in Power BI Report Builder.
• You can publish to My Workspace. For any other workspace, you need at least a Contributor role.

Create a paginated report based on a Power BI shared dataset - Power BI | Microsoft Learn