When trying to view dimension on PowerBI desktop, error appears.
Unable to connect we encountered an error while trying to connect
This is caused by incorrectly configuring API connector in cloud.
Solution is to delete the connection from PowerBI and re-configure API. Below are steps to do that.
1. Go to File in PowerBI desktop Options and Settings> Data Source Settings
2. Then select the data source, then delete (using delete key).
3. Go to cloud APIselect all modules and save.
4. Then create new connection in PowerBI with new API URL and access code.
Applies to: Cloud