Forum Discussion

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

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":

 

Then I will receive the following error message:

 

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

 

Need Help

5 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    5 years ago

    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.

    • selimovd's avatar
      selimovd
      Most Valuable Professional
      5 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi, 

         

        Is your problem solved? I have the same issue. 

         

        Cheers,

        Allen

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    5 years ago

    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

  • why_so_Saad's avatar
    why_so_Saad
    New Member
    3 years ago

    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