Issue with Power BI Report builder

[Anonymous]

Hi Guys,

I got a requirement of creating Paginated reports so, I got installed Power BI Report Builder. and It got  connected to the data source and when connecting to the datasets It is giving me the below error.

Regards

Phaneendra

[Anonymous · Accepted solution]

Hi All,

The issue has been excalted to Microsoft and they informed me that my id should be in the live connections. 

See Image below.

Regards

Phaneendra

[v-jayw-msft]

Hi @Anonymous ,

You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues.

Best Regards,

Jay

[amitchandak]

@Anonymous , either user or the Ip from which you are connecting has an issue.

Are you connecting a Datasource to connecting via power bi dataset?

Make sure you are still logged in using power bi user, in case you are using the power bi dataset. And you still have access to that dataset.

In case of DB it can credential issue. Or Ip access issues. (report builder machine might not have access)

[Anonymous]

@amitchandak 

I am connecting to Power BI dataset.

I have created a Workspace, so I am the admin and when I am connecting to the dataset I am getting the error.

My IT team are trying to figute out what might be the issue but not getting any idea.

Regards

Phaneendra

[amitchandak]

@Anonymous , Just check if your one-premise gateway is working or not. It should have role in case of import mode, but direct query it has.

Also double-check login in power bi report builder. It should you login or the one having access to dataset.

You can check the permission of dataset, Open workspace -> go-to dataset, hover over it. On three dots manage permission -> Check access to the users.

[Anonymous]

@amitchandak 

we are using Azure SQL, so OAuth2 it is working fine. 

Report is on Direct Query only. I am the admin of the workspace and also i am using the same account for Power BI and report builder.

still getting the error.