Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table surgeon sales in which I have 3 columns, order id, npi id and party id.
When I refresh the model in pbix file it works fine but when it is refreshed in service it shows the foll error
While trying to test the issue i tries to publish in another workspace I am getting the following error
The source of my data is oracle sql, and the column npi id is basically numerical value but in the database we have some names in this column, hence that column shows as data type text. I need those columns also for my report, is there any other way by which we can move refresh this model and not get this error.
Solved! Go to Solution.
Hi @Avivek ,
Please try to enter into Query Editor in Power BI Desktop, go to APPLIED STEPS, find the step named "Changed type" , delete this step.
Also, you can go to File -> Options and settings -> Options ->CURRENT FILE ->Data Load, don't tick the option "Detect column types and headers for unstructured sources", restart the Power BI Desktop to take effect of this change.
Then republish the report to power bi service and try to refresh it to check.
In addition, here are some simliar issues that you can refer which could help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Avivek ,
Please try to enter into Query Editor in Power BI Desktop, go to APPLIED STEPS, find the step named "Changed type" , delete this step.
Also, you can go to File -> Options and settings -> Options ->CURRENT FILE ->Data Load, don't tick the option "Detect column types and headers for unstructured sources", restart the Power BI Desktop to take effect of this change.
Then republish the report to power bi service and try to refresh it to check.
In addition, here are some simliar issues that you can refer which could help you:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Avivek ,
Check with column data types on Power Bi desktop, if there is any mismatch make it porper.
And I can se the dta refresh is taking long time. Please Aggreagate the data and have less records to perform better. If you are using SQL, Oracle type DB then try to load incrementally. That will create Partition and load faster.
Regards,
Manikumar
Proud to be a Super User!
@Avivek , check if the gateway working properly. But there is some issue with data type. Refesh the data in desktop and see if you get the error ?
for Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
@amitchandak , the gateway is fine because the other models do not show error. Also suprisingly it shows no issues in the desktop file when refreshed.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |