Re: Want to Transfer a Report and all of its Measu...

Anonymous · ‎09-28-2022

I have a query named (Data) that is not refreshing due to an error (OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).

I made a copy (Data1) of the (Data) query that points to the exact same data source. When I refresh Data1 I have no errors.

How do I transfer everything I have built in Data to Data1?

parry2k · ‎09-28-2022

@Anonymous it is weird if both data and data1 have the same steps and one is giving the error and not the other one. did you make any changes after you copied the queries?

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎09-28-2022

I did not make any changes to the underlying data source (Excel Sheet). Does that mean my original Query named "Data" has an issue instead of the data source having the problem?

Anonymous · ‎09-28-2022

To follow up with my original question...can I transfer all of my created measure formulas) over to "Data 1" and all of my Report's individual pages?

Anonymous · ‎10-05-2022

Hi @Anonymous,

Perhaps you can try to parameterize your report and save it as a template, then you can simply use the template file to generate a new table based on new connection strings.

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI
Regards,

Xiaoxin Sheng