synchronize current time on desktop and fabric
hello, i wanna synchronize current time on desktop and fabric 1. this is my power bi desktop 2. this is my power bi fabric dashboard before auto refresh by schaduler 3. this is my power bi fabric dashboard after auto refresh by schaduler 4. this is my schadule setting 5. this is my refresh history how to syncronize this ?? after i schaduler the data source to current time ???
DM_GWPipeline_Gateway_MashupDataAccessError (Not like other post)
So I have multiple reports that pull from 1 or 2 MySQL databases, Most pull from the same database in which I get this error. The "table" at the end of the error varies. And this error is not constint, some days out of the 6 reports I get 1 or 2 of the reports that get this error message, some days I dont get any, and about 10 mins before this post I got all 6 (same error message minus the table at the end). Now If I go to power bi > data sources > and manually click the refresh I never get any errors, this only occurs randomly during the auto refreshes. I made sure my On-Premises Data Gateway is up-to-date and refreshed/restarted it. The MySQL connections are good with encription not enabled and under Orginization not public. This has been happening off and on for about a month now. I would normaly think it would be something on my end, but if it was I wouldnt be able to refresh it without errors via the power bi site or on the desktop editor as well. So Im sure its a odd setting somewhere, anyone have any ideas?
Automatic refresh OData
Hi, I used OData in Power BI. I want to set up automatic refresh but I'm getting an error. I am pulling data into Power BI with the gateway on another employee's computer, but I cannot see this gateway in online Power BI. As in the image below: Also, I cannot update in online Power BI and I get the following error: When I enter the connection settings in the 'Manage Connection and Dataset' area, I select basic as the authentication method. I enter the username and password I have to access the data. The save button is active, but nothing happens when I click it. (Extra information: Gateway Cluster Name: personal mode). Where am I making a mistake? Also, as far as I know, in this scenario the computer must be on during the automatic renewal process. Is there a way to automatically refresh data that does not require the computer to be turned on?
Error when setting up credentials for on prem report server
I have a report I have created in PBI Desktop from a SQL server database. I can connect to the server from PBI desktop and can enter the sql query details in the advanced box. I have published this report successfully to our on prem report server. I then went to set up an auto refresh for this report. When I typed in my credetials and tested, this is the error I got; Microsoft SQL: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The server has been configured correctly for remote connection so that isn't the issue. I can open the report in PBI Desktop, refresh it and then save with no problems. Could this be a server configuration issue or potentially a firewall issue between our Report Server and the SQL Server? I don't have this issue with any of the other databases I use on different servers in our network.
