Skip to main content

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!

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” 

 

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!

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

 

 

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

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

@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