Forum Discussion

eRic_LaU's avatar
eRic_LaU
Frequent Visitor
1 year ago
Solved

PBIRS setup problem

Dear All I'm using PBI desktop to create a report connected with MySQL database and would like to share through intranet, so I download & install the PBIRS at the server but can't figuare out how to...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, eRic_LaU 

    PBIRS typically require a SQL Server database for internal configuration and storage. If you only have MySQL, you may need to install SQL Server as the configuration database for PBIRS. MySQL can be used as a data source for reports, but not as a configuration database for PBIRS.
    You need to set up a SQL Server database first. PBIRS needs this database to store its configuration and report metadata. Without this setting, you'll encounter an error when you try to configure the Web Service URL and Web Portal URL. You can check the folloing link:

    SQL Server installation guide - SQL Server | Microsoft Learn

     

    If setting up PBIRS and SQL Server isn't feasible, you might consider using Power BI Service, a cloud-based service, to share your reports. This allows you to publish your reports to Power BI Service and share them over your network. Alternatively, you can export the report to PDF or PowerPoint and share it manually over the intranet.

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

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

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, eRic_LaU 

    You may need to select the Manage

    Then select Data source to complete your data source information

     

    You can check the following link:

     

    Manage content in the Power BI Report Server web portal - Power BI | Microsoft Learn

     

    If you want to know more about it, you can go and check out the official documentation:

    Power BI Report Server documentation - Power BI | Microsoft Learn

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

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