PowerBI Paginated Report cannot see Dataset in MyWorkspace

[MikeSolvesBI]

Hello,

I am attempting to connect to a PowerBI Dataset in MyWorkspace from Power BI Paginated Report.

I have a PowerBI Dataset but this is not visible from Power BI Paginated Report Builder.

Is there a setting that I need to apply?

Thank You,

Michael

[v-zhangti · Accepted solution]

Hi, @MikeSolvesBI 

What you need:

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

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Hoping]

Having the exact same issue. Unable to access datasets pubslished to My Workspace from Report Builder.

I have a Pro licence and I am able to see datasets in other workspaces where I am a Contributor but not MyWorkspace where I am the admin.

[jeff122333]

I have the same issue (dataset not visible). I have a pro account, have bild permission, etc. but still can't see any data. In another thread someone mentioned going to  power bi services and copying the connection string under "server settings". The issue there is the dataset has not "server settings". Help! I had this all working a year ago but I'm on a different account and nothing is working.