- Hi Everyone,
I am new to Power BI.
I had created reports with 'Import' options. Now reports are completed and published. But now we want to switch from 'Import' to 'Live' (DirectQuery). But power Bi doesn't allow it. I tried the below workaround for that.
https://community.powerbi.com/t5/Desktop/Solution-Changing-datasource-from-Import-to-Direct-Query-gt/td-p/246569
But the challenge is, It is not recognizing any of the field. Because initially when I created the reports, the Table names were 'T2' and 'T3' after that the tables names got changed in database. So I used Navigation option and pointed to new tables instead of creating new tables. So 'T2' and 'T3' became 'V_Scrm_LOA' and 'V_LOA_Measures' respectively. but all measures and fields remain as T[field] and T3[field]. But now when I tried the above option mentioned in the link, it is not recognizing any of the field because now all fields become v_scrm_LOA[field] and V_LOA_measures[field].
Is there any way so that I can get all fields again? Please find the attached error.
Thanks!
Regards,
Poonam
Forum Discussion
Power BI : Switch from Import to Live (DirectQuery) Connection Issue
2 Replies
Hi Anonymous
Does this error occur when the table name change after changing import to directquery?
Based on my knowledge, when you create visuals using columns or measures, if in directquery or live mode, it would send queries to the data source and return results from it. Thus, when the table name changes, it would not match the columns and get the correct results.
Best Regards
Maggie
Hi v-juanli-msft,
Thanks for your reply!
No, Table name got changed in Database when I was connected through 'Import' only. All reports I created using 'Import' and even published on Power BI server. When Table names got changed, I used 'Navigation' option from 'Edit Query' and Navigated from old table names to new tables. After that I was trying to switch from 'Import' to 'Direcquery' and because in that case I beleive, power BI found only new tables. and all my field were refering to 'Old table' names. What can be done in this situation? Do I need to create whole report again with 'Direcquery' option?
Thanks!
Regards,
Poonam
