OAC : Folders Empty When Connecting From Microsoft Power BI Desktop
(Doc ID 2973945.1)
Last updated on NOVEMBER 03, 2023
Applies to:
Oracle Analytics Cloud - Version N/A and laterInformation in this document applies to any platform.
Symptoms
After following the steps in Connect to Oracle Analytics Cloud from Microsoft Power BI, connection gets established successfully and folders are visible, but not the contents within. Only a warning saying folder is empty is seen.
In Microsoft Power BI Desktop,
- From the home page, click Get Data, locate and select Oracle Analytics (Beta) in the list of connectors, then click Connect.
- In the Instance URL field, paste in or specify the Power BI App Key that you obtained in Step 1.
- In the Logical Query (optional) field, if you've copied SQL from a workbook or report, paste in or enter the SQL code.
- Click OK.
It fails with below error:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |