Solved

Loading CDF table to Power BI with errors

  • 21 July 2023
  • 6 replies
  • 85 views
N
Rank

Hi,

I need to connect to CDF with Power BI and when trying to load the table, I get this error:

It only loads a limited rows of data (probably those rows have no errors) and I cannot change the format of the fields in PBI.

I already whent thru the documentation , but the solution provided there does not work in this case (there is no option to change the data format).

For other datasets (other data sources), where Power BI encounters errors, the data is still loaded (with errors), but in this case, the data is not loaded and the import is stopped by the error. This is also keeping for saving the report or using the data source.

The behavior needed is that PowerBI is loading the entire dataset with errors and to change the field format before importing the data.

Thank you!

icon

Best answer by Ankit Kumar 9 August 2023, 16:15

View original

6 replies

A
Rank
Userlevel 2
Badge

Hi , Can you select the setting as shown below i.e. “Never detect column types..” and then try loading your CDF project table. While loading click on Transform and not Load and then try transforming the data types of this column to String.

Just to let you know this error has been highlighted before and the recommended solution was as per documentation above to “ingest the values into CDF RAW as strings instead of numbers” 

 

N
Rank

Hi! Thank you for your reply!

I have the “Never detect column types..” selected:

 

The steps that I am doing to get to the data that I need:

Step 1: get the list of tables (I also changed the option to: Column profiling based on entire dataset):

Step 2: get the list of tables that I need:

Step 3: get the table:

Step 4: get the records. In this step the error is already there and it blocks the data to be loaded:

Only after this I get to Expand the data, but the Error is in this step where I cannot change the format.

Do you have a suggestion for this case?

Thank you!

A
Rank
Userlevel 2
Badge

When you are here , are you clicking Load or Transform:

 

 

N
Rank

That’s the first step that I do, then I have all the steps from my previous comment.

A
Rank
Userlevel 2
Badge

Sorry for late response..but in this case then you need to modify the column on server and change the column type to 'String' and then connect to Power Bi..as mentioned in the documentation

C
Rank
Userlevel 3

@Necula Simona-Elena, have you been able to sort out your issue? :) If so, you can mark the most helpful answer for you as best answer. 

Reply


Terms & ConditionsCookie Settings