Forum Discussion

odegarun's avatar
odegarun
Advocate II
8 years ago

Solution: Changing datasource from Import to Direct Query -> SUCCESS

Hi all   I recently wanted to change the datasource from Import to Live Query using the "Power BI service" and had a good lookaround without turning up much other than "you can not"...   However ...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi odegarun,

 

Thank you for sharing this. I tried this in my pbix file. But it seems I have to create all measures. but for Dimensions also it is not showing anything. My guess is because when I had created pbix file with 'Import' option, that time the table names were 'T2' and 'T3'

for 'v_scrm_loa' and 'LOA_measures' respectively and after that they got changed so I had used Navigaton option instead of creating new reports and navigated those tables to new table names respectively. So now when I am applying the above steps to switch from 'import' to 'Live' it is not recognizing all fields as previoulsy all fields were like T2[field]/T3[field] not it became v_scrm_loa[field] and v_LOA_measure[Field]. Is there any way so I can atleast recover all fields. I will create measures but can I cover all fields (Dimension) again?

Thanks!

 

Regards,

Poonam