Forum Discussion

fayzy100's avatar
fayzy100
New Member
11 months ago
Solved

Time Intelligence Functions Not Working After Changing Database Source in Advanced Editor

Hello Community, I’m facing a recurring issue in Power BI related to Time Intelligence DAX functions after modifying the data source. Issue Summary When I change the database connection using the ...
Need Help
Tips and Tricks
  • AnalyticPulse's avatar
    AnalyticPulse
    11 months ago

    hi, fayzy100 
    when i had multiple data sources in my project i used parameters for the database name, i never faced any issue, we used to change dadtasource dynamically from parameters without touching the source code. when you change the datasource powerbi will change the internal column ids, even though your columns have similar names their ordering ids will be different, can you confirm which data source you were using in dev and what is in prod?



     

    My Work:
    Analytic Pulse Blog 
    Docynx Productivity Tools 

raisurrahman's avatar
raisurrahman
Icon for Helper II rankHelper II
11 months ago

fayzy100: 

Thanks to AnalyticPulse and v-dineshya for their valuable insights.

As far as I know, there are two ways to resolve this:

      1. Use parameters to switch between data sources.
      2. Create connection queries for each data source, then reference connection queries wherever needed.

It looks like you’re loading the data directly in Power BI; you should load it through Power Query instead.