March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi PBI Community,
I'm currently stuck with the following error:
Backstory
I am attempting to create a report in PBI Desktop (February 2020) with a DirectQuery connection to a PostgreSQL database. I have 5 tables within the report (a centralised Date table and 4 e-commerce data tables, all of which have a Date column). I am able to build visualisations within the report with data from the various tables individually without any problems but when I make a relationship in the data model between the DateTime table and any of the e-commerce tables (necessary) I get the above error.
Trouble-shooting thus far
Trawling through the interwebs, some posts have vaguely suggested that this error may be due to trying to join mixed data types (I can confirm all of the Date columns I'm trying to relate are of the same underlying format) or joinAlgorithms (I don't have any table joins or merges, as far as I am aware)(@ImekF solved this one, might be able to help here?).
I am at a loss. I include below a sample of data for each table.
Date table
E-commerce tables follow same format as below
Hopefully someone can help, and many thanks in advance!
Did you get it resolved? I'm also stuck in the same issue and unable to resolve it. Your help with this would be highly appreciated.I am using Direct query connection with snowflake.
Hi @Anonymous ,
I always try to avoid DirectQuery mode or reduce it to simple queries.
Hence my questions:
- Do you really need DirectQuery mode?
- Can you merge the queries with SQL beforehand?
Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials
Hi @mwegener ,
Thanks for your reply.
The purpose of this report is to provide near-real-time-data to stakeholders in our business, and given that we are using Pro licences (read: 8 times/day refresh not timely enough), DirectQuery is necessary.
I will look into the viability of combining the data into one SQL query but if we can find a PBI solution or at least an explaination for why this error is occurring that'd be great. 🙂
Any news?
Maybe a fix/workaround?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
83 | |
76 | |
62 | |
58 |
User | Count |
---|---|
141 | |
122 | |
105 | |
94 | |
90 |