PBIRS setup problem

[eRic_LaU]

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 setup, and have the follow quesiton would ask for help:

1.  After install & connected to the server, I can't change the database at the configuration mangaer 

I only got MySQL and don't have SQL, any way to solve this problem? 

2. Do I need to setup the database first before i can create the Web URL? Cause it pop up error while i connect to the "Web Service URL" / "Web Portal URL"

3. Or should i use other way to share the report to intranet?

Looking for someone help, thanks a lot.

[v-yohua-msft · Accepted solution]

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.

[eRic_LaU]

Thanks it work, I have futher question want to have your help! After I have load into the report server. I have saved a pbix make up desktop previsouly but when I try to open it only conitnuous loading data and nothing more.

When I try to check "About Power BI Report Server" at "Help" error pop up

May I know what's the issue? Thanks.

[v-yohua-msft · Accepted solution]

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.

[eRic_LaU]

Dear Yongkang,

Thanks for your great help, after setting up the data source the report still keep loading and one more issue i'm now using free trial version. Is that the reason i don't have embed function? or is just i havn't setup the data source?

[v-yohua-msft · Accepted solution]

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.