Dataflow number of tables in data warehouse is not matching the number of tables in Power Bi Desktop

[martin93]

Hello,

I am trying to create a data model for reporting in the dataflow. But when I join the Oracle database through dataflows I can not see all the database tables and in the opposite I can see everything through Power BI desktop. Do you have any clue why this discrepancy could occure?

Thank you in advance for your help,

Martin

[v-shex-msft · Accepted solution]

HI @martin93,

I think this should be related to your gateway setting and data source credential verifications steps. Can you please share some more detail to help us clarify and troubleshoot your scenario?

How to Get Your Question Answered Quickly  

For power bi desktop, you can directly connect your data source based on your connection string. If you are working on the power bi service, it requires a gateway to handle the connection from power bi to the data source.

You can also take a look at the following links about power bi data source support and power bi service URL if these request has been blocked by your device settings:

Power BI data sources - Power BI | Microsoft Docs

Add Power BI URLs to allowlist - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[bcdobbs]

How are you connecting to the Oracle database through dataflows?

1) Are the credentials the same if you're connecting directly?

2) If you're connecting to something On Prem check what account is configured for use in the gateway.

It sounds like dataflows is connecting with an account which has lower permissions.