Cannot connect to MySQL database
Hi, I'm having a problem connecting Power BI to a MySQL DB. I'm connecting to localhost and then select the database 'monitore_perfileducacion'. I don't know why but this error comes up when it appears everything's alright. And if I try to connect to the IP that appears at the workbench connections in MySQL it doesn't work. How can I fix this? I tried everything in almost every available post. DataSource.Error: MySQL: Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Unknown database 'monitore_perfileducacion' Details: DataSourceKind=MySql DataSourcePath=localhost;monitore_perfileducacion Message=Authentication to host 'localhost' for user 'root' using method 'caching_sha2_password' failed with message: Unknown database 'monitore_perfileducacion' ErrorCode=-2147467259 The screen looks like this, and if I press refresh in the preview, the error is shown. Thing is, the connection is alright in MySQL.
How To Connect Power BI to Hosted MySQL Database
Good day house, Please, I am currently experiencing a challenge with Power BI and will appreciate any help/suggestion I can get. I have a MySQL database which is hosted on Godaddy (cPanel hosting) and want to connect to it using Power BI desktop. I have installed the recommended connector (MySQL Connector/Net 6.6.5 for Microsoft Windows) and attempted the connection with (hostname, IP address, IP address: port etc)but I keep receiving the error below. Has anyone else resolved this? I'll really appreciate your help. Thanks in advance.
PWA oData Feed not loading 'Project' table
I have a data set in Power BI connected to my organization's PWA oData Feed. For some reason the 'Proejcts' table is not loading, but all others appear to be loading. ------------------------------------------ There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Data source typeOData Processing errorOData: An error occurred while processing this request. Cluster URIWABI-US-EAST2-redirect.analysis.windows.net Activity ID240f6ea2-c6ec-4460-a86a-aa2de57d917a Request IDed2aea01-fc78-4860-b538-598b9aae1dcd Time2017-08-23 19:17:19
Remove the data source
Hi, How can I remove previous data sources in Power BI Desktop. Actually I am getting an error when I try to connect to Oracle Database since morning, actually we upgrade database and add new port to the database. Since then I am getting following error. Is there anyone else encountered the same thing before?Data source is offline - suspected is Exchange (Mail) issue - But Refresh Status Complete
I have configured the data gateway. I have 3 data source: Power BI Dataflow, SQL (for SAP Simplement) and Exchange (Mailbox). So for SQL, I connect it to the gateway and it is offline. For both Dataflow and Exchange, I put in my credential, no error pop out. However, when i refresh my data, it didn't shows any error but based on refresh history, it is completed in split secs and I checked my data is not refresh. Even scheduled refresh doesn't work too. I suspect is the Exchange issue but also cannot confirm. Anyone can help me with this?
