Set-up data source in power bi report server
Hi, In our company we want to set-up a deployment startegy, we have three Power bi report server environment (dev,test,prod) . we just use power bi desktop and Power BI report server . We will be using direct query sql server, my question is that we should set-up the data source each time we change the environment. we use the powershell command Write-RsRestCatalogItem to upload the report. I was wondering if there is a way that username and password of the sql db will be transmitted when the user publish from power bi desktop to power bi report server. and from the power bi report server to the different environment thanks
Report Refreshing Problem - SQL Server Database
My report was connected to a SQL database with "import" method. It extract data from a stored procedure with an "EXEC spXXXXXX" syntax. I have set a "Scheduled refresh" for 8 times per day. However, when my computer was shut off and SQL Server Management Studio offline, my Power BI report cannot refresh and the scheduler would automatically turned off. In order to keep this report update, I have to keep the SQL Server Management Studio online every morning, somtime I refresh the dataset manually. The error message said "Your data gateway (personal mode) is offline or couldn't be reached." Any solution to this problem?
Sql server not connecting through power bi in Virtual Machine
Hello Members, I am unable to connect to sql server database from my power bi which is installed in my VM. So basically I'm under client;s vm which has Power bi Desktop and from there I am unable to connect to their sql server database. Please look at the SS for error. Error Message:
cannot open .pbix on desktop but can open it online
Hi, My dashboard works online, but after download .pbix I cannot open it on PowerBI desktop. I have set a gateway to the SQL server for powerBI online. Here is the error message on desktop： “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.);No such host is known. The exception was raised by the IDbConnection interface.” If anyone can help thanks a lot. P.S. Happy new year!
