Forum Discussion

datapal04's avatar
datapal04
Helper I
3 years ago

Appending Queries & Refresh

Hello,   I am developing a Power BI report based on CRM data. Our team has been told to use a new CRM system - however some of the data in this new CRM system is still not accurate, so I am queryin...
General Comment
Need Help
Tips and Tricks
DougieK's avatar
DougieK
Frequent Visitor
3 years ago

datapal04 I have the same challenge with the added complexity of a native query to SQL Server for both 1 and 2.  Finally got IR to work on 2 with Advanced Editor & SQL injection - passing in Text.From(RangeStart/End) to the where clause.  However, appending kills IR for me in 3.  

edhans Thanks so much for the insight here.  Figured the Table.Combine() re append was the issue, and I think you're eluding to it there but keeping the fact tables separate and using something like Union in Dax (if that's even possible) isn't ideal. 

In my case, I have a bunch of New Columns in the appended table so I need a final fact table to use. 

Maybe if my Native Query (2 in pal's situ) queried source tables in a Dataflow setup with IR I'd be fine.  But I think Dataflows require Premium and I need a Pro solution.