Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have created a Power BI report using Direct Query to Oracle Data Warehouse. Its working fine in the Power BI Desktop. But when i have published it to the Power BI service and tried to access that report, its showing the below error. I have verified the Gateway connections and they are all working fine.
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please try again later or contact support. If you contact support, please provide these details.
hi, @Anonymous
Please go to the dataset settings of this report, make sure the data gateway used by dataset is running fine.
And which version of Oracle DB you have? There are 12 and above which are under support for Direct Query - https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources
Best Regards,
Lin
Hi @v-lili6-msft I have verified the settings & the Gateway is running fine. Also the Oracle DB version is 12. The same report works in our Production Office 365 tenant but it didn't worked in my test tenant. We have Power BI Pro licenses also.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.