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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
selimovd
Super User
Super User

Power BI Report Builder Error 403 Forbidden

Hello everyone,

 

for a customer I have to create some paginated reports. The reports should be based on an existing data set in a premium workspace. I am an admin of the premium workspace, so I should have full access.

 

I use Power BI Report Builder and can connect to the Power BI Dataset connection.

 

I try to create a dataset and click on "Query Designer":

selimovd_0-1619771177925.png

 

Then I will receive the following error message:

selimovd_1-1619771235046.png

 

I have never experienced that error before. The data set has the data imported but there is no scheduled refresh. I tried with another report that has an Azure SQL database as source with a scheduled refresh. I still get the same error.

 

Does anyone have an idea why that error happens and how I could solve it?

 

Thank you and best regards

Denis

 

5 REPLIES 5
why_so_Saad
New Member

I faced the same problem. For me it was a data source that had been depricated. I changed all my datasets to refer to the newer available sources but forgot to delete the data source. Once I deleted that depricated data source, everything went back normal 

v-kkf-msft
Community Support
Community Support

Hi @selimovd ,

 

Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

 

Best Regards,
Winniz

v-kkf-msft
Community Support
Community Support

Hi @selimovd ,

 

Paginated reports require Read permission. Only Import mode and DirectQuery Power BI datasets are supported. Report queries using a DirectQuery Power BI dataset as a data source have a fixed 10 minute time-out. For report queries taking longer than 10 minutes, use the Power BI dataset's XMLA Read/Write endpoint as the report data source.

 

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-data-sources

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

Hey @v-kkf-msft ,

 

the error still appears.

As I wrote the data set has the data imported. So all the DirectQuery things don't apply.

 

Do you have any idea what that could be?

 

Thank you and best regards

Denis

Hi, 

 

Is your problem solved? I have the same issue. 

 

Cheers,

Allen

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors