Trouble updating in Power BI service

[ines1902]

Hi!

I have a Power BI report that I've "inherited" from another analyst. It works fine to update it in the desktop, but the scheduled refresh keeps failing and I'm struggling to figure out why that is. Any help would be appreciated! This is the error message: 

[powerbidev123]

Hi @ines1902 ,

The error message suggests that the issue is related to a Power Query transformation, specifically with a function that is not being recognized correctly in the Power BI Service.

Possible Causes and Fixes:

1. Power Query Function Issue

   • The error states:

     "We cannot convert the value FunctionFunctionFunction to type Function."

   • This could mean that a custom function in Power Query is not resolving properly in the Power BI Service but works in Power BI Desktop.
   • Fix:
     • Open Power Query Editor (Transform Data) in Power BI Desktop.
     • Look for any custom functions being used in transformations.
     • Ensure that all functions are properly defined and invoked.
     • Try removing and reapplying function transformations.

2. Gateway Configuration Issue (If applicable)

   • If your data source requires a gateway (e.g., SQL Server, on-premises Excel, etc.), ensure that it is configured properly in Power BI Service.
   • Fix:
     • Go to Power BI Service → Settings → Manage Gateways and check if the gateway is online and properly set up.

3. Cloud vs. Desktop Data Handling Differences

   • Power BI Desktop can sometimes process queries differently than Power BI Service.
   • Certain data types or query steps might work locally but fail when published.
   • Fix:
     • Check for steps in Power Query that might be dependent on local execution.
     • Ensure that all tables and columns are properly loaded.

4. Credentials Issue

   • If the dataset requires authentication, incorrect credentials can cause failures.
   • Fix:
     • In Power BI Service, go to Settings → Datasets → Edit Credentials and ensure the correct authentication method is used.

5. Query Folding Issue

   • If your Power Query transformations prevent query folding, it could lead to failures in Power BI Service.
   • Fix:
     • Test disabling some complex steps and reloading the dataset.

[v-sgandrathi]

Hi @ines1902.,

Thanks for reaching out to the Microsoft Fabric Community forum.

Thankyou @powerbidev123 for your reply on the issue.

I'm glad to hear that your query was resolved! If the response provided by the community member addressed your concern, kindly confirm.

Marking it as Accept Answer and give us Kudos if you found it helpful allows us to ensure that the solutions shared are valuable for the entire community.

If you have any further questions, feel free to reach out!

Thank you for your cooperation!

[v-sgandrathi]

Hi @ines1902,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thanks for connecting with the Microsoft Fabric Community Forum.

[ines1902 · Accepted solution]

Hi @v-sgandrathi!

Sorry for my late reply. The thread I linked below ended up being the solution to my problem!! 🙂 

Solved: Re: Underlying error message: We cannot convert th... - Microsoft Fabric Community

[v-sgandrathi]

Hi @ines1902,

I'm glad you found a solution and resloved  the query. Thank you very much for sharing here.

Kindly mark your reply as the accepted solution so that others in the community can find it quickly.

Thankyou for connecting with Microsoft Community Forum.

Have a great day ahead.

[v-sgandrathi]

Hi @ines1902,

I'm glad to hear that your query has been resolved! Thank you for sharing the solution here.

To help others in the community find it easily, please consider marking your reply as the accepted solution.

Thankyou for using  Microsoft Community Forum!